of course there's always this
foreach ($result as $r) {
if (!empty($r['Module'])) {
$data[] = $r;
}
}
$result = $data;
but i'd prefer to do this on a db level if I can
On Mar 2, 4:13 pm, WebRenovator <[email protected]> wrote:
> Hi all ye thrifty helpers
>
> I'm trying to use the containable behaviour for a somewhat complex
> query. I've gotten most of it to work. The only anomaly is that I want
> the containable to contain a condition for the actual query. Here's
> what I have:
>
> var $hasAndBelongsToMany = array('Module');
> var $actsAs = array('Containable');
>
> $result = $this->find('all',array(
> 'conditions'=>array('Assessment.disabled'=>0),
>
> 'fields'=>array('Assessment.id','Assessment.name','Assessment.material_link','Assessment.compliance_id'),
> 'contain'=>array('Module'=>array('conditions'=>array('Module.id'=>
> $userId))),
> 'order'=>'Assessment.id ASC'
> ));
>
> Here is one of the results
>
> [Assessment] => Array
> (
> [id] => 1
> [name] => Test 1
> [material_link] => link1
> [compliance_id] =>
> )
>
> [Module] => Array
> (
> )
>
> )
>
> The query works, except that I don't want this record to show up at
> all. If it had had a module attached then it should show up, otherwise
> this record should not return at all.
>
> For what its worth, I previously had it working with the following
> query:
>
> $this->bindModel(array('hasOne'=>array('AssessmentsModule')));
> $conditions = array('AssessmentsModule.module_id'=>$userId);
> $result = $this->find('all',array(
> 'conditions'=>array('or'=>$conditions,'Assessment.disabled'=>0),
>
> 'fields'=>array('Assessment.id','Assessment.name','Assessment.material_link','Assessment.compliance_id'),
> 'recursive'=>0,
> 'order'=>'Assessment.id ASC'
> ));
>
> I'm sure there's something small I'm missing, but haven't figured it
> out, due to the fact that cake doesn't join this but rather runs it in
> 2 or so queries.
>
> The reason for all this is that I need to add another condition into
> the query from a different model and I'm hoping to use contains to
> help me out a little.
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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
