1. ggaillet
  2. Support
  3. Saturday, April 24 2021, 12:09 AM
  4.  Subscribe via email
Wouldn't think it was hard but I can't for the life of me make this Custom SQL WHERE work. I have a user group called SA342. I simply want to display a Userlist (table) of the members who belong to this user group. I use group_id IN (SA342) and get 0 users found. I do have users in this user group. What am I doing wrong?
admin Accepted Answer
the ID of the this Usergroup is 33, you cam see it from Users->Groups, so the custom SQL where should be:
group_id IN (33)

Now i have already set it so for you :)
  1. 2 weeks ago
  2. Support
  3. # 1
ggaillet Accepted Answer
Thanks! I am so dumb! :(
  1. 2 weeks 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.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.


Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy ProfileĀ® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.