Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 10:38 pm
Add a reply View Replies (2)

Resolved SQL Where not working for groupID

  1. oliviergut
    oliviergut
  2. Support
  3. Monday, October 09 2017, 10:07 PM
Hi
I tried to filter my memberlist by those members, that are either in the Joomla user group 9 or 11.
I entered the custom code in the SQL where field of the menu item: "group_id IN (groupid9,groupid11)" (see screenshot)
Unfortunately the search form shows 0 users although there are users in the two user groups.
Can you help me there?
Attachments (1)
Unbenannt.JPG Unbenannt.JPG
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it was night for us.

The correct syntax is something like: "group_id IN ( 9 , 11 )"
  1. more than a month ago
  2. Support
  3. # 1
oliviergut
oliviergut Accepted Answer
Hi
No worries, it was night then for us too :-)
Thanks for the syntax. It is working now.
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.