Hello,
I created a radiolist field with the values “Available” and “Unavailable”. I also created a page to display users in a specific joomla group. So i’d like to give the right for these users to hide from the list just by selecting the value “Unavailable” with no need to delete them from the Joomla group.
Regards,
-
Arena Esport
- Support
- Wednesday, July 20 2016, 02:04 PM
Hi,
you can use "SQL Custom Where" to filter users with this field set to "Available", for example
I assumed Usergroup ID is 10 and radio (with alias "listavailability"
list have these options:
0|Unavailable
1|Available
So You can put in SQL Custom Where something like this:
you can use "SQL Custom Where" to filter users with this field set to "Available", for example
I assumed Usergroup ID is 10 and radio (with alias "listavailability"
list have these options:0|Unavailable
1|Available
So You can put in SQL Custom Where something like this:
group_id IN (10) AND listavailability="1"