Hi,

It seems to be wrong, because it doesn't work

It mean that you see a empty list?

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".

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.

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.

IT works perfect!!
you're a genius! thank you a lot!