Support

    You are here:  
  1. Home
  2. Support
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: Tuesday 9:16 am
Add a reply View Replies (9)

Resolved Custom SQL Where

  1. namly161
    namly161
  2. Support
  3. Monday, August 22 2016, 01:17 PM
Hi admin

please support for me about list users.

When administrator login to manager list users. List users showed all users have group parent relation with group parent user admin.

But i don't write how sql. Please for me sample
Attachments (1)
aaa.jpg aaa.jpg
Responses (9)
admin
admin Accepted Answer
Admin
Hi,
in docs page you will see many examples to filter users from some usegroups: http://docs.easy-profile.com/article/sql-custom-where
  1. more than a month ago
  2. Support
  3. # 1
namly161
namly161 Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
you can simply create 2 userlists:
Userslist 1:
- Set Access only for Manager 1 (with Joomla ACL)
- Show Users from usergroup Group A with SQL custom Where, example at http://docs.easy-profile.com/article/sql-custom-where

Userslist 2:
- Set Access only for Manager 2 (with Joomla ACL)
- Show Users from usergroup Group B with SQL custom Where, example at http://docs.easy-profile.com/article/sql-custom-where
  1. more than a month ago
  2. Support
  3. # 3
namly161
namly161 Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 4
namly161
namly161 Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 5
admin
admin Accepted Answer
Admin
Hi,
no sorry, keep in mind that, due to timezone, maybe for us it's night. for example your previous post was written at 05:01 AM. We open at 9:00 AM but we have answered you at 8:41 AM.
  1. more than a month ago
  2. Support
  3. # 6
admin
admin Accepted Answer
Admin
How to write 2 SQL custom Where with 2 groups. I don't know technology.
Sorry I not understand, you need to create 2 different menu items of type Easy Profile->User List

And when I (manager) login to frontend list users. So how to write sql or ... to show list users (registered) from group of my account
You can't, but you can create a menu item of type Easy Profile->User List only for Managet (with Joomla Access) and set (if needed) SQL Custom Where to get only specific usergroup
  1. more than a month ago
  2. Support
  3. # 7
namly161
namly161 Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 8
admin
admin Accepted Answer
Admin
set where and how.

In the parameter "SQL Custom Where" (see screenshot 1)
with filter like example at http://docs.easy-profile.com/article/sql-custom-where:


group_id IN (5)

"5" is a example, you can retrieve group_id from Users->Groups (there is ID column)

some clarification
you can create different list with different Menu Items:
for example:
1. list of users from usergroup "5"
2. list of users from usergroup "6"
3. list of users from usergroup "7"

for each menu item Joomla allow you to set "Access" (see screenshot 2), so you can make available the List to those who prefer.
so for example
Manager 1 can see list of users from usergroups "5"
Manager 2 can see list of users from usergroups "6"
....
Attachments (2)
list 1.png list 1.png
list 2.png list 2.png
  1. more than a month ago
  2. Support
  3. # 9
  • 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
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.