Reference qualifier advance

tylerduren7
Tera Contributor

Create a catalog item withe following details:
Item name : Add User to a Group
Variables:
1. Please select the user. ( it should show list of all the active users so that we can select one )
2. Select the Group. ( it should be showing all the active groups where the user is not already member of it )

 

Please give me solution for this

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@tylerduren7 

do this

1) 1st variable add this reference qualifier -> active=true

2) add this in 2nd variable ref qualifier

javascript:'sys_idNOT IN' + new global.ArrayUtil().convertArray(gs.getUser().getUserByID(current.variables.firstVariable).getMyGroups());

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

16 REPLIES 16

 

@tylerduren7 

it should work fine.

Please use the advanced ref qualifier and share the screenshots of output

which user you selected? which groups it's showing now?

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Here is the output screenshots Where george is already in four groups

@tylerduren7 

it did work fine for me when I tested

I am part of 1 group so it didn't show me that group when I selected the group variable

See below

 

AnkurBawiskar_0-1750320192318.pngAnkurBawiskar_1-1750320494478.pngAnkurBawiskar_2-1750321548512.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

 

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

Thanks for the help now it's working