How to populate Assignment group in RITM?

[User205031]

Hi All,

There is a variable 'support group' which is a select box type with group names and I want to populate assignment group in RITM with the support group selected. How to achieve since Assignment group is a reference field and Support group is a select box field. Support group variable value is being send from 3rd party.

I have written a client script & script include but its not populating:

Client Script:

function onLoad() {

    var a = g_form.getValue('support_group');

    alert(a);

    var ga = new GlideAjax('SupportGroupHandler');

    ga.addParam('sysparm_name', 'getAssignmentGroup');

    ga.addParam('sysparm_group', g_form.getValue('support_group'));

    ga.getXMLAnswer(response);

        function response(serverResponse) {

            var answer = serverResponse.responseXML.documentElement.getAttribute("answer");

             alert('Line 12' +answer);

                g_form.setValue('assignment_group', answer); // sys_id returned from Script Include

        }

        //return;

        //Type appropriate comment here, and begin script below

    }

Script Include :

var SupportGroupHandler = Class.create();

SupportGroupHandler.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getAssignmentGroup: function() {

        gs.log('hiline6');

        var supportGroup = this.getParameter('sysparm_group');

        gs.log('hiline10' + supportGroup);

        var groupSysId = '';

        var a = new GlideRecord('sys_user_group');

        a.addQuery('name', supportGroup);

        a.query();

        if (a.next()) {

            groupSysId = gr.getUniqueValue();

        }

        return groupSysId;

    },

    type: 'SupportGroupHandler'

});

Value is not populating in Assignment group.

Is anything wrong with the script?

[Deepak Shaerma · Accepted solution]

Hi @User205031 ,

• Trigger: Service Catalog (or Record Created: sc_req_item).

• Action 1: Get Catalog Variables

  • Get the variables for the Submitted Request (RITM).

  • Select your Support Group variable.

• Action 2: Look Up Record

  • Table: Group [sys_user_group]

  • Conditions: Name is [Trigger > RITM > Variables > Support Group]

  • Note: This action searches the Group table for a group where the name matches your variable string.

• Logic: If (Safety Check)

  • Condition: [2. Look Up Record > Group Record] is not empty.

• Action 3: Update Record (Inside the "If" block)

  • Record: [Trigger > Requested Item Record]

  • Fields: Assignment Group = [2. Look Up Record > Group Record]

Note: Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards 
Deepak Sharma

[Ankur Bawiskar · Accepted solution]

@User205031 

yes that's not possible as it's select box

-> You can use lookup Record on sys_user_group with condition as 

Name = Get Catalog Variables -> Variable Name

-> then while you update the Group, you can grab the output from Lookup Record data pill and set it

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@User205031 

I believe I also shared the same working solution.

As per new community feature you can mark multiple responses as correct.

💡 If my response helped, please mark it as correct ✅ as well so that this helps future readers find the solution faster! 🙏

[ursnani]

Hi @User205031 

You need to do a Lookup record first for Group and then reference the group to populate Assignment group on RITM.

Please mark my Answer as correct/Helpful if it is useful

Thanks