How to populate Assignment group in RITM?

User205031
Tera Contributor

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?
2 ACCEPTED SOLUTIONS

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

 

 

View solution in original post

@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! 🙏

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

View solution in original post

17 REPLIES 17

Hi @ursnani ,

 

I was trying to do that but cant since Assignment group is a reference field and support group is a choice field. Not able to select support group for Assignment group.

 

User205031_1-1763358620433.png

 

Bhavya11
Kilo Patron

Hi @User205031 ,

 

you have wrongly fetched the information

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 = a.getUniqueValue();//use a.getUniqueValue instead of gr.getUniqueValue

        }
        return groupSysId;
    },

    type: 'SupportGroupHandler'
});

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(function(response){
	if(response){
		  alert('Line 12' +response);
		 g_form.setValue('assignment_group', response); // sys_id returned from Script Include
	}

   });
}
If this information proves useful, kindly mark it as helpful or accepted solution.

Thanks,
BK

Deepak Shaerma
Mega Sage

Hi @User205031 

use update record action in flow designer, and set the assignment group directly without any coding,
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


Hi @Deepak Shaerma ,

 

I was trying to do that but cant since Assignment group is a reference field and support group is a choice field. Not able to select support group for Assignment group.

 

User205031_0-1763358581752.png

 

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