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:21 am
Add a reply View Replies (4)

Resolved Skip usertype

  1. wilbert
    wilbert
  2. General
  3. Tuesday, September 19 2017, 09:01 AM
I like to show only the registered users in my overview of profiles? (skip superusers etc..)

How to?
Responses (4)
admin
admin Accepted Answer
Admin
Hi,
you can use parameter called "Custom SQL Where" to set static filter in menu item options, please see examples at http://docs.easy-profile.com/index.php/article/sql-custom-where, you can exclude some users or some usergroups.
  1. more than a month ago
  2. General
  3. # 1
wilbert
wilbert Accepted Answer
Pro
Yes, but if I use this sql, no results shown (also not a message)

group_id IN (groupid2)

This group_id? is this related to the usergoups, I hope?
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Of course, you can get usergroup ID from Users->Groups, normally in a standard Joomla installation Super Users usergroup have id equal to 8, so to exclude Super Usets then it become something like 


group_id NOT IN (8)
  1. more than a month ago
  2. General
  3. # 3
wilbert
wilbert Accepted Answer
Pro
thanks this helps..
  1. more than a month ago
  2. General
  3. # 4
  • Page :
  • 1


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