Support

  1. peacetree
  2. General
  3. Wednesday, June 26 2019, 02:20 PM
  4.  Subscribe via email
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 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


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

Request Support

Support is currently Online

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.