Support

    You are here:  
  1. Home
  2. Support
  3. privacy controle can only be chosen ones at registration
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 7:19 pm
Add a reply View Replies (5)

Resolved SQL Custom Where combined don't work

  1. Jeansuizo
    Jeansuizo
  2. General
  3. Thursday, May 03 2018, 07:22 AM
hi,
I combined the original custom where "user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0)"
with "group_id NOT IN (55)" this way:

user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0) AND group_id NOT IN (55)

It seems to be wrong, because it doesn't work
What would be the correct syntax? (I just want to see all the registered visitors except some users who are in the hidden administration group.)

Thank you
Responses (5)
Jeansuizo
Jeansuizo Accepted Answer
IT works perfect!!
you're a genius! thank you a lot!
  1. more than a month ago
  2. General
  3. # 1
admin
admin Accepted Answer
Admin
Hi,
this is not a bug, this happen because probably users in usergroup 65 are also in some other usergroup.

try with this:
user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0)  AND user_id NOT IN (SELECT user_id FROM #__user_usergroup_map WHERE group_id IN (65))


We need something like this because there is a INNER JOIN between Joomla User Table and Joomla Usergroups Table.
  1. more than a month ago
  2. General
  3. # 2
Jeansuizo
Jeansuizo Accepted Answer
I noticed that it works only with following combination:

user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0) AND user_id NOT IN (990,1107,1109)

but doesn't work like this:

user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0) AND group_id NOT IN (65)

could be a bug?

For practical reasons I would need the second option.
  1. more than a month ago
  2. General
  3. # 3
Jeansuizo
Jeansuizo Accepted Answer
No, the module appears, with the same users, it seems as if the exclusion would not work


I controlled every factor: the group number is oK, group assignation too, but no way to make it disappear from the list.

For example: I activated the new group "virtual user" (ID Nr 65) for the test user "test registrado", and with " user_id IN (SELECT DISTINCT userid FROM #__session WHERE client_id=0) AND group_id NOT IN (65) all users see this user in module "who is online".
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
Hi,
It seems to be wrong, because it doesn't work
It mean that you see a empty list?
  1. more than a month ago
  2. General
  3. # 5
  • 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.