Support

    You are here:  
  1. Home
  2. Support
  3. Avalon_MediaHr
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (5)

Resolved Is there a way to create user list based upon a specific ACL

  1. amanda_sage
    amanda_sage
  2. Support
  3. Tuesday, July 28 2015, 12:38 AM
My client wants to list two different types of profiles on their site, both based upon two separate ACLs ("students" and "clients";).

I didn't see a way to do this in the user list menu item. Am I missing something? Thanks.
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
in List menu item and in modules you can find parameter called "SQL Custom Where", it allow you to filter users by custom field value or by complex query. Try to read docs at https://www.easy-profile.com/docs/69-sql-custom-where-list-and-module.html, here you can find some examples (also how to filter by usergroups)
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (5)
admin
admin Accepted Answer
Admin
Hi,
correct syntax is:
user_id IN ( SELECT user_id FROM #__user_usergroup_map WHERE group_id IN ( 11,12 ) GROUP BY user_id HAVING count( user_id )=2 )
  1. more than a month ago
  2. Support
  3. # 1
alsage13
alsage13 Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
yes, this is possible.

see following examples at doc page:
1. Include some Usergroups
2. User From 2 Groups at the same time
3. User From 3 Groups at the same time

1. include all users in at least one of usergroups
2.3. all users in all specified usergroups at the same time
  1. more than a month ago
  2. Support
  3. # 3
alsage13
alsage13 Accepted Answer
Ok, I'm back with another question. Is it possible to list more than one user group in the same directory with this method?

So for example, I want to list the users in groups 11, 12, and 13 in this one particular directory. Is that possible?
  1. more than a month ago
  2. Support
  3. # 4
amanda_sage
amanda_sage Accepted Answer
Basic
Oh, totally missed that. THANK YOU!
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Online
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

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.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.