Scratch variable not getting the values to the list variable

[ServiceNow Use6]

Hi,

I have created a display business rule and an onLoad client script. It is not working, and the groups are not loading onto the field User Groups (u_user_groups).

Display Business Rule

(function executeRule(current, previous /*null when async*/ ) {
    
	var aq = [];
    var gr = new GlideRecord('sys_user_grmember');
    gr.addQuery('user', gs.getUserID());
    gr.query();
    while (gr.next()) {

        aq.push(gr.getValue('group'));
    }
    g_scratchpad.sreevani = aq;

})(current, previous);

onLoad Client Script

function onLoad() {

	var Suman = g_scratchpad.cloeh;
	if(g_form.isNewRecord()){
	g_form.setValue('u_detailed_description', Suman);
	}
}

But when I put in List variable, it is not working.

function onLoad() {

	var Suman = g_scratchpad.cloeh;
	if(g_form.isNewRecord()){
	g_form.setValue('u_groups', Suman);
	}
}

Regards

Suman P.

[J Siva · Accepted solution]

Hi @ServiceNow Use6 

Your scratchpad variable is storing the group record sys_ids,

But, in the dictionary entry pic, I can see that the reference table is "Employee Stay Request" table. 

Please check that..

Regards,

Siva

[ServiceNow Use6]

Hi @J Siva,

Thank you so much. It worked. I am stupid, instead of pointing to the groups table, I pointed out to the table i am working on.

Regards

Suman P.

[J Siva]

@ServiceNow Use6 

Sys ID is a unique value across the instance. In your scratchpad variable, you're storing the Sys IDs of group records from the Group table. However, you're attempting to assign these IDs to a field that references the 'Employee Stay Request' table. That's why it didn't work.

[J Siva]

@ServiceNow Use6 Glad it helped