Web Designer - Display list of users depending on the information of the logged in user in the web portal

Good Morning,

I have a custom configuration parameter which is defined in a customized CCC_Employee_Overview.module. This is displaying a list of users depending upon 2 checks - person should be active and CCC_Col_8 (extended attribute on the Person table) is True.

The condition I have is the following -

"CCC_Col_8 = 1 AND IsInActive=0"

The parameter's type is SQL filter condition.

The parameter's Object type is Person.

I now need to add another criteria in this condition where it should also take a look at the 'CompanyMember' value of the logged in user and then display all users in the Person table who have the same 'CompanyMember' value in their record.

Any suggestions would be really appreciated.

Thank You

Mohit Singh