Advanced filter in CB List

Hi
I'm a little confuse with the Advanced filter of cb list.

On a one hand, we should use SQL format (SELECT FROM WHERE) and in tutorial 33 (YouTube) we should use ue.'cb_xxx'..

1 - For me, ue.'cb_xxw' doesn't work.

2 - where can i find the list and uses of table of CB (for exemple #_session, #cbsubs_subscriptions' .....

3 - I would like to filter a list of users online with the same 'gender' that the user connected' like :

( ( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` ) > 0 and cb_gender='female' ) works

( ( SELECT COUNT(*) FROM `#__session` AS s WHERE s.`userid` = u.`id` ) > 0 and cb_gender=$cb_gender ) doesn't works



Is there a documentation about all that.

Thanks a lot.
Best regard.

1 - For me, ue.'cb_xxw' doesn't work.

That's because you're using single quotes. You need to use ` not ' for columns and table escaping. Single quote is for value escaping. Please read up on MYSQL documentation and SQL tutorials found below carefully to become more familiar with SQL.

Documentation: dev.mysql.com/doc/refman/5.6/en/index.html
Tutorials: www.w3schools.com/sql/default.asp

2 - where can i find the list and uses of table of CB (for exemple #_session, #cbsubs_subscriptions' ....

Browse your database using phpmyadmin or whatever database software you host provides.

3 - I would like to filter a list of users online with the same 'gender' that the user connected' like :

You would need to have something like the below.

Online:
Offline:
The substitution will substitute in the viewing users gender. This will likely return no results if you're viewing as a public user since they won't have a gender field value so I recommend making the userlist accessible to registered users only.

Please see the below tutorial for further substitution usage information.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

Hello,

But in the list, how to show users online in first and then offline ones Following?
Or sort by last date first visit?
It must also write a manual request?

Thanks

Sorting by last connections works fine for me ...(users online th en offline)

Hi,

Yes, but how have the users online at the beginning of the list, for me it's mixed!

This topic is regards to an Advanced Filter. Sorting is a completely different query and usage. I'm guessing you're sorting by Last Online field, which is just a datetime; it's not an indication of them actively being logged in. To sort by online status you need to use an Advanced Sort By which adds directly to the ORDER BY of the query. The below Advanced Sort By will probably work.

Online First

Offline First