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

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Siva,

you can add filter to that list collector variable; user is active and it would only show active users

Are you using any script to populate the list collector? if yes then in that script you can add that code

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

Hi Ankur,

 

We have a filter that can run manually at every time. But I need the list of user should display only for active users dynamically in slush bucket to select the group member.

Hi Siva,

Didn't get it completely. If you could explain what variables you are having on catalog item and what should happen when?

Regards
Ankur

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

Hi Ankur,

It's not related to catalog item. I want to add some group members to one group.

While adding group members, 

1. Open the group.
2. go to group member tab and click edit option to add member.

Added attachment. Please check