Forums

Hello,

Using CCv5, I'm trying to use the next condition to filter only articles from logged user and from specific categories.
Nevertheless,categories are filtering OK but user->id are not working, and CCv5 is showing items from all the users.

What I'm doing wrong?

<?php
$user =& JFactory::getUser();
return array('UPNoticias.created_by' => $user->id, 'UPNoticias.catid' => ('4','6','27','36','69'));
?>

Hi Kronosites ,

If you add a Debugger action you will see the MySQL query that is being created - really useful when you need to debug the code.

The first condition looks OK to me though is should now be $user = \JFactory::getUser();

The second condition is broken as there is no IN there. Please try 'UPNoticias.catid IN' => ('4','6','27','36','69')

Bob

Hi again GreyHead,

Using it doesn't work.
I was searching through the FAQs more harder (https://www.chronoengine.com/faqs/72-ccv5/5215-how-do-i-build-a-where-statement-in-ccv5.html)and I found the solution:

return array('created_by' => $user->id, 'UPNoticias.catid' => array('4','6','27','36','69'));

Thanks for all!
Your FAQs are really great😉

Hi Kronosites,

It's also advised to use v6 instead of v5 for more features and flexibility.

Best regards,
Max