Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. 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: Saturday 1:46 pm
Add a reply View Replies (3)

Resolved Easy Profile - User List only for Registered Users

  1. messagedj
    messagedj
  2. Features Request
  3. Tuesday, March 31 2015, 01:04 PM
we are using EasyProfile for several weeks now,

we have these the Easy Profile - User List module to shows our members, but it also shows the Super User and moderators. Would it be possible to only show the register users ?
Accepted Answer
admin
admin Accepted Answer
Admin
You can filter users with "SQL custom where" parameter (in module or menu item), docs with examples at: https://www.easy-profile.com/docs/69-sql-custom-where-list-and-module.html

Example of value to include only registered users:
group_id IN (2)


Example of value to exclude admins,managers or authors
group_id NOT IN (8,3,6)


You will find group ids from Administration->Users->Groups
  1. more than a month ago
  2. Features Request
  3. # Permalink
Responses (3)
messagedj
messagedj Accepted Answer
Content Protected
  1. more than a month ago
  2. Features Request
  3. # 1
messagedj
messagedj Accepted Answer
so this is successful, but one last question about this. how do i filter

Registered users that have an avatar?

something like...??
group_id IN (2) HAVING avatar <> true
  1. more than a month ago
  2. Features Request
  3. # 2
admin
admin Accepted Answer
Admin
You can use something like this:
group_id IN (2) AND avatar<>''

or
group_id IN (2) AND avatar LIKE '%/profiler%'


NOTE: some Mysql version accept 
!=
instead 
<>
as Not equal operator
  1. more than a month ago
  2. Features Request
  3. # 3
  • 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.