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 2:25 am
Add a reply View Replies (0)

Resolved select user that are in one group and also in another group

  1. peacetree
    peacetree
  2. General
  3. Wednesday, June 26 2019, 02:20 PM
I have two different groups and some members are part of multiple groups.

I would like to display members of group A but only when they do not appear also in group B.

so all members of group A but only if they dont appear also in group B.

Can you help me?

Thank you : )
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
you can use a Custom SQL Where like
group_id IN (15) AND user_id NOT IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id IN (12))

where 15 is the ID of the Group A and 12 is the ID of the Group B
  1. more than a month ago
  2. General
  3. # Permalink
Responses (0)


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