Need to show group members on a catalog item form

[Suzanne_Ryan]

I've been searching the community and the wiki and I have seen several ways that people have said they've done this, but none of them are working for me.

Here is my scenario:

The request is for the review of an assignment group and will be sent to the assignment group manager for fulfillment.   It is to be filled out by the ITSM management team.  

A reference field is filled in with the Assignment Group name by the requester.

A client script populates the Assignment Group Description field and the Assignment Group Manager field.   Easy as pie.

There is a field for the members of the assignment group, and one more for the CI's associated with this assignment group.   I haven't gotten to the CI field yet, but I think it will work similarly to the assignment group members.

I know which table holds the membership information (sys_user_grmember), and I know that a script will provide the information, but I've seen   a business rule, a script include, a client script and I think a UI policy floating around the community.  

And none of them work for me.   I'm not sure which one if them is the correct place to script this.   And   I'm not sure if the field on the form should be a reference field, or a wide single line text, or not even a field, just a message that shows up.       Or a list collector...

Looking for clarity and assistance on this one...   Thanks in advance.  

Suzanne

[Kalaiarasan Pus · Accepted solution]

and yes , there was a typo

script :

function assignmentGroupUsers()

{

      var group = current.variables.assignment_group;

      var user_array = [];

      var getMembers = new GlideRecord('sys_user_grmember');

      getMembers.addQuery('group',group);

      getMembers.query();

      while(getMembers.next())

              {

              user_array.push(getMembers.getValue('user'));

      }

      return 'sys_idIN' + user_array.toString();

}

i have set up a demo for you ...

goto

https://demo002.service-now.com/login.do

username : admin

password : admin

catalog to check

https://demo002.service-now.com/com.glideapp.servicecatalog_cat_item_view.do?v=1&sysparm_id=e2132865...

[Suzanne_Ryan]

Thanks, I'll give it a try!!

Suzanne Ryan | Desk 818.887.8435 | Cell 818.974.1350 | Enterprise Service Desk 877.285.0550

[Suzanne_Ryan]

Great… thanks so much for the demo. It works like a champ. I'll set it up in my item and make sure I can duplicate it.

Suzanne Ryan | Desk 818.887.8435 | Cell 818.974.1350 | Enterprise Service Desk 877.285.0550

[Kalaiarasan Pus]

perfect .. if the solution works for you , mark the question as answered so that others can check the solution if they face the same issue

[Suzanne_Ryan]

I will do that. Working on it now in the demo.

Thanks again!

uzanne Ryan | Desk 818.887.8435 | Cell 818.974.1350 | Enterprise Service Desk 877.285.0550