Support

  1. darkolive
  2. Support
  3. Friday, April 20 2018, 03:55 PM
how do I write query so:
display users who are in group_id 1 AND not in group_id 2
darkolive Accepted Answer
Basic
thank you that did it
  1. more than a month ago
  2. Support
  3. # 1
admin Accepted Answer
Admin
Hi,
you have right, we need a SQL Where a bit more complex to make this, you can use something like:
user_id IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id IN (1,2) GROUP BY user_id HAVING count(user_id)=1) AND group_id IN (1)


We need something like this because there is a INNER JOIN between Joomla User Table and Joomla Usergroups Table.
  1. more than a month ago
  2. Support
  3. # 2
darkolive Accepted Answer
Basic
Thats what I thought, but not working.

Interestingly, if I put

group_id IN (1) AND group_id IN (2)

the user of both groups does not show either, but

group_id IN (1)

and

group_id IN (2)

both work
  1. more than a month ago
  2. Support
  3. # 3
admin Accepted Answer
Admin
Hi,
you can use something like

group_id IN (1) AND group_id NOT IN (2)
  1. more than a month ago
  2. Support
  3. # 4
  • 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.

Guidelines

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.