Databases
StackOverflow2013
Postsdbo
POcakephp cakedc search plugin - multiple table / multiple query search
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcakephp cakedc search plugin - multiple table / multiple query search
    primarykey
    data
    text
    <p>I am having some issues searching from multiple tables. I have a keyword search setup on a cards model which works fine, I also want the keywords to look into a contact model which has a forign key of card_id. I cannot seem to work out how to go about this.</p> <p>The points to look at / with issues are the <code>findByContacts</code> function and:</p> <pre><code>array('Contact.street_suburb' =&gt; 'contacts', 'type' =&gt; 'subquery', 'method' =&gt; 'findByContacts', 'field' =&gt; 'Card.id'), </code></pre> <p>I have initially tried to just get the suburb to search but ideally I would like any of the fields within the contacts model to come up on the card search.</p> <p>Thanks!</p> <p>My code in Card Model is as follows:</p> <pre><code>public $filterArgs = array( array('name' =&gt; 'keyword', 'type' =&gt; 'query', 'method' =&gt; 'filterQuery'), ); public $hasAndBelongsToMany = array('Contact' =&gt; array('with' =&gt; 'Contact')); public function filterQuery($data = array()) { if(empty($data['keyword'])) { // keyword is the name of my search field return array(); } $query = '%'.$data['keyword'].'%'; return array( 'OR' =&gt; array( array('Card.name LIKE' =&gt; $query), array('Property.name LIKE' =&gt; $query), array('Building.name LIKE' =&gt; $query), array('Stage.name LIKE' =&gt; $query), array('Contact.street_suburb' =&gt; 'contacts', 'type' =&gt; 'subquery', 'method' =&gt; 'findByContacts', 'field' =&gt; 'Card.id'), ) ); } // END SEARCH // FIND BY CONACTS - PART OF SEARCH // ------------------------------------------------------------------------------------&gt; public function findByContacts($data = array()) { $this-&gt;Contact-&gt;Behaviors-&gt;attach('Containable', array('autoFields' =&gt; false)); $this-&gt;Contact-&gt;Behaviors-&gt;attach('Search.Searchable'); $query = $this-&gt;Contact-&gt;getQuery('all', array( 'conditions' =&gt; array('Contact.street_suburb' =&gt; $data['contacts']), 'fields' =&gt; array('foreign_key'), 'contain' =&gt; array('Contact') )); return $query; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAnne
    1. USsluggerdog
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POcakephp cakedc search plugin - multiple table / multiple query search
      1. USsluggerdog
      1. VTFavorite
    1. COi think you are missing a couple of things, but can you define not working? what exactly is NOT working? does it search for the cards correctly? does it search for the contacts correctly? does it do a query at least? or simply doesn't do anything at all?
      singulars
      1. POcakephp cakedc search plugin - multiple table / multiple query search
      1. USapi55
    2. COThanks, the error I get when above in in place is: Warning (512): SQL Error: 1054: Unknown column 'Contact.street_suburb' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 684] I guess this means the contact and card models are not linking correctly...
      singulars
      1. POcakephp cakedc search plugin - multiple table / multiple query search
      1. USsluggerdog
    3. COI get a similar error when I try to search multiple tables.
      singulars
      1. POcakephp cakedc search plugin - multiple table / multiple query search
      1. USCharles Blackwell
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload