Hi all,
i have 2 tables: competition, competition choices.
In my model the definitions are as follows:
Competition:
var $hasMany = array(
'CompetitionChoice' => array('className' =>
'CompetitionChoice',
'foreignKey' =>
'competition_id',
'dependent' =>
false,
'conditions' =>
'',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'exclusive' =>
'',
'finderQuery'
=> '',
'counterQuery'
=> ''
),
Competition_choices:
var $belongsTo = array(
'Competition' => array('className' => 'Competition',
'foreignKey' =>
'competition_id',
'conditions' =>
'',
'fields' => '',
'order' => ''
)
);
Now I have a listing of competition choices and I have a filter form which
will filter the listings. Now I want to filter by the competition name but I
am not sure what to do.
In my competitions_choices controller, do I need to set a condition for the
paginate section as example:
$this->paginate = array(
'conditions' => array(
"competitions.name like
'%".$competitionSearchParam."%'"
)
);
$this->set('competitionChoices',
$this->paginate('CompetitionChoice',
$filter));
I tried this but it didn't I also tried the following:
$filter[] = "competitions.name like
'%".$competitionSearchParam."%'";
$this->set('competitionChoices',
$this->paginate('CompetitionChoice',
$filter));
This also didnt work. I am not sure how to search for the competition name
as its the table that is connected to the competition_choices table by
competition_id.
Please if anyone can help or send links or tell me where I am going wrong I
will be grateful.
Thanks in advance.
Angelo
--
View this message in context:
http://www.nabble.com/Filter-on-BelongsTo-relationship-tp20697216p20697216.html
Sent from the CakePHP mailing list archive at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
