Re: afterFind : possible to get query type?

I use the pagination, but there is quite a weird condition in the query:

Here is the query going to the database:

SELECT `Article`.`id`, `Article`.`author_id`, `Article`.`cat_id`,
`Article`.`last_comment_id`, `Article`.`title`, `Article`.`teaser`,
`Article`.`created`, `Article`.`published`,
`Article`.`numeric_visibility`, `Article`.`like_count`,
`Article`.`comments_count`, `Article`.`visitations_count`,
`Article`.`hidden`, `Article`.`flag_top`, `LastComment`.`user_id`,
`LastComment`.`created`
FROM `articles` AS `Article`
LEFT JOIN `users` AS `ArticleAuthor` ON (`Article`.`author_id` =
`ArticleAuthor`.`id`)
LEFT JOIN `comments` AS `LastComment` ON (`Article`.`last_comment_id` =
`LastComment`.`id`)
WHERE
`Article`.`numeric_visibility` >= 3
AND MATCH(`Article`.`title`, `Article`.`teaser`, `Article`.`body`,
`Article`.`denormalized_tags`) AGAINST('"ocean"' IN BOOLEAN MODE)
AND `Article`.`hidden` = 0
AND `Article`.`deleted` = 0
AND `Article`.`published` > 0
ORDER BY `Article`.`updated` DESC LIMIT 8

The part with the "match" is added in a special method
$cond = $this->_getSearchConditions($search);
$cond is an array, to which other conditions are added before it goes
via beforeFind and afterFind to the view as a paginated result.

Anja

Am 22.08.2011 16:45, schrieb Thomas Ploch:
> Woops, actually Model::findQueryType is __not__ reset before afterFind()
> is triggered. You should normally be able to check for
> Model::findQueryType in the afterFind() Callback.
>
> Are you using custom find types?
>
> Regards,
> Thomas
>
> Am 22.08.2011 16:33, schrieb Anja Liebermann:
>> did that. It is always NULL :(
>>
>> Anja
>>
>> Am 22.08.2011 16:25, schrieb Thomas Ploch:
>>> Look at Model::findQueryType :-)
>>>
>>> Am 22.08.2011 15:56, schrieb Anja Liebermann:
>>>>
>>>> Hello,
>>>>
>>>> is there a possibility to know which query type ( first, all, count
>>>> etc...) was used, when I call afterFind()?
>>>>
>>>> Depending on the query Type I would like to make different checks.
>>>>
>>>> If it is not possible, then I have to do it in the controller in
>>>> several actions.
>>>>
>>>>
>>>> As always: Thanks in advance for any hints!
>>>>
>>>> Anja
>>>>
>>>
>>
>

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php