How to filter dynamically Active users while selecting group member from slush bucket

Sivakumar7
Kilo Contributor

Hi Friends,

Issue:

I have created a new user group and added group members. One of the group member is not active now.
So the inactive user is removed through edit option. It will show slush bucket and moved the user to left side and saved.

Now If I try to add the same inactive user to the group. In slush bucket I am able to select the inactive user and add as group member too.

Requirement is, Inactive user should not be displayed dynamically in slush bucket to select as group member. How can we achieve this?. Please help me on this!!!

Regards,

Siva

1 ACCEPTED SOLUTION

Hi Siva,

there is a query business rule on sys_user table which only shows active users; this BR won't run for admin. So I assume you must be testing with some non-admin user

when you click the edit button it brings user from user table; this BR should be respected and it should show only active users

Can you check anybody updated the query business rule on sys_user table?

BR Name: user query

Steps:

1) Configure List Control

find_real_file.png

2) you can set filter as below; Edit Default filter as Active -> true

find_real_file.png

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

5 REPLIES 5

Hi Siva,

there is a query business rule on sys_user table which only shows active users; this BR won't run for admin. So I assume you must be testing with some non-admin user

when you click the edit button it brings user from user table; this BR should be respected and it should show only active users

Can you check anybody updated the query business rule on sys_user table?

BR Name: user query

Steps:

1) Configure List Control

find_real_file.png

2) you can set filter as below; Edit Default filter as Active -> true

find_real_file.png

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader