Hi there,
I am trying to get a list of members from an RBAC table (authAssignment) using scopes.
The join seems to be working in that it is getting the count correct (the pagination component). However it is brining out all the results. Is there anyone out there who could shed light on the problem?
public function scopes()
{
return array(
'member'=>array(
'with'=>array(
'authAssignment'=>array(
'joinType'=>'RIGHT OUTER JOIN'
),
'person',
),
),
'nonMember'=>array(
'with'=>array(
'authAssignment',
'person',
),
)
);
}