Is ClientUser model always associated? As I know, Containable demand association for models in "contain".
On Aug 21, 3:51 pm, Adrian <[email protected]> wrote: > Btw when I add debug($queryData); it confirms the contain array is > present: > > app\models\ticket.php (line 175) > > Array > ( > [conditions] => Array > ( > [Ticket.ticket_status] => New > ) > > [fields] => Array > ( > [0] => Ticket.ticket_id > ) > > [joins] => Array > ( > ) > > [limit] => 51 > [offset] => > [order] => Array > ( > [0] => > ) > > [page] => 1 > [group] => > [callbacks] => 1 > [contain] => Array > ( > [ClientUser] => Array > ( > [fields] => Array > ( > [0] => ClientUser.user_group_id > ) > > ) > > ) > > ) > > But it is not taking effect in the sql: > > Warning (512): SQL Error: 1054: Unknown column > 'ClientUser.user_group_id' in 'where clause' [CORE\cake\libs\model > \datasources\dbo_source.php, line 525] > > Query: SELECT `Ticket`.`ticket_id` FROM `tickets` AS `Ticket` WHERE > `Ticket`.`ticket_status` = 'New' AND > `Ticket`.`ticket_support_group_id` = 2 AND `Ticket`.`ticket_status` != > 'Deleted' AND ((`Ticket`.`ticket_client_group_id` = 84) AND > (`ClientUser`.`user_group_id` = 204) AND (((`Ticket`.`ticket_openedby` > = 1024) OR (`Ticket`.`ticket_client_user_id` = 1024)))) LIMIT 51 > > On 21 Aug, 09:24, Adrian <[email protected]> wrote: > > > > > Hi > > > I am trying to set my contain array from within the models beforeFind > > () callback so a certain model is always contained. I have the > > following code: > > > function beforeFind($queryData) { > > // Always contain the client user > > if(empty($queryData['contain']['ClientUser'])) { > > $queryData['contain']['ClientUser']['fields'] = > > array > > ('ClientUser.user_group_id'); > > } > > return $queryData; > > } > > > should this not work? > > > At the moment the find operations just ignore this. > > > Any ideas? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
