need to populate assignment group members in list collector field

lata1
Tera Contributor

Hi all,

I have group field(reference to group) when i select any group, that group members need to populate in list collector field(List collector reference to user ).

i want to show that particular group members in list collector field remaining group users i want to restrict...

Thanks in advance...

 

27 REPLIES 27

Hi,

since you want users to be shown in the slush bucket why to refer to sys_user_grmember table; you need to refer to sys_user table for this variable

Any reason for using sys_user_grmember table?

Regards
Ankur

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

She wants to show the group members in the slush bucket of the selected group.

That's correct; but I think the variable should refer to sys_user table

I think pointing to sys_user_grmember will show record of Group Member and not user specific record;

Also sys_user_grmember doesn't have any field which is Display=True so it would always show sys_id in the slushbucket

Regards
Ankur

 

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

Swapnil Soni1
Giga Guru

Hi Lata,

If you want to create in record producer or catalog Below are steps that I used to meet your requirement.

1. Created a record producer on Requested Item (you can change)

2. Add reference field for user.

3. Added ListCollecter.

 

Below are screen shots

find_real_file.png

find_real_file.png

find_real_file.png

find_real_file.png

find_real_file.png

Hope this will help you.

Please Hit Correct, ️Helpful depending on the impact of the response

Hi Swapnil,

 

sys id is coming..not user name

find_real_file.png

reference:

javascript:'group='+current.variables.group

Attribute:

ref_qual_elements=group,ref_ac_columns=group.name,no_filter

any change required for getting username?

Thanks in advance...