Thank you Kyle

Thank you Kyle,

I reviewed it and this is beyond my level of comfort with modifying. I am comfortable with SQL scripts but I do not where to insert it in the users.php.

Let me explain what I have:

1. A table created by me (my_pointer_relevant) that among other thing has the following fields:
a. current_user field (login user)
b. member_user (members in different groups that would be relevant to the current_user)

2. My script: (used in other selections)

SELECT $user IN
(SELECT DISTINCT my.member_user
FROM my_pointer_relevant my
WHERE my.current_user = [user_id])
FROM CB\Database\Table\UserTable

note: this script the users that login user should be seeing while logged in despite of any other that might across (my goal is that despite of how users among groups, 10,000, 1 million, etc., the logged user would only deal with the relevant member in each group for which the user is a member instead of the entire population)

my question is where I should insert the short script to take advantage of substitution without limiting functionality? I do not know enough to see it this goes in users.php as I did not see SQL script in there.

Yes, it is user specific. Once the user logs in, that user should only see the members filtered, in all groups in which the user belongs and it could be extended to member list if possible, for now I am focusing in the groups

Question: Is the [FIELD_NAME], the name of CB Query field that I will be creating for the filtering purpose and if hidden from tab?

This is very powerful! I should contact you before!

Thank you