copy a string value to a reference field

[Snow Dev5]

Hi SNOW Dev,

Is it possible to assign a string value to a reference field? For example,assignment group is a reference field, and I'd like to assign "Team Acme" (String) to an assignment group field like the below.

assignment_group = "Team Acme"

I tried it but didn't work. Thank you in advance.

[MrMuhammad]

Reference field require sys_id or Display value. I can see you have used 'database' group so in that case the display value is "Database" with capital D.

Best way is to take the sys_id of Data base group and try like this.

gr.assignment_group = 'SYS ID HERE';

if you want to use Display name then try this.

gr.assignment_group = 'Database';

Please mark this correct & helpful if it answered your question.

Thanks & Regards,
Sharjeel

[Snow Dev5]

Hi Sharjeel,

var gr = new GlideRecord ('incident');
gr.addEncodedQuery('numberSTARTSWITHINC0009009');
gr.query();

if (gr.get('287ee6fea9fe198100ada7950d0b1b73')){
//Database group sys_id

gr.assignment_group.setDisplayValue('Database');

gr.update();

}

Could you take a look? Once again, thank you!

[MrMuhammad]

Let's debug this. I have placed few logs lets run your fix script and see what you got in the logs. 

var gr = new GlideRecord ('incident');
gr.addEncodedQuery('number=INC0009009');
gr.setLimit(1); // return only one record. 
gr.query();

gs.info("SNOW DEV - " + gr.getRowCount());

if(gr.next()) {

 gs.info("SNOW DEV - " + "record Found!");
 gr.assignment_group.setDisplayValue('Database');
 gr.update();

}​

Select Proceed from the dialog box and share me the screenshot of logs you got once fix script executed completely.

Thanks & Regards,

Sharjeel

[Snow Dev5]

Thank you!

[MrMuhammad]

Wow! Happy Learning Sir.