use fix script to update all location records name field with comma separated existing value and country field value.

[shashank32]

use fix script to update all location records name field with comma separated existing value and country field value.

can anyone help .

[Mark Roethof]

Hi there,

Can you share what you've tried so far? Can you share where you are stuck? Can you share where exactly you need help with?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Akshay H Mulky]

Hi,

Can you try below script:

var gr = new GlideRecord('cmn_location');
//gr.addQuery('sys_id', 'xsdsfdfeeffsfsfw345r'); // testing with one record
gr.query();

while(gr.next())
{
gr.name+= ", " + gr.country.getDisplayValue();
gr.update();
}

[Ankur Bawiskar]

@shashank 

Not sure what exactly is required but here are the steps for fix script

1) left nav type fix scripts

2) create new

3) Give name, select Run Once

4) Sample script below

updateLocation();
function updateLocation(){
	try{
		var gr = new GlideRecord('cmn_location');
		gr.query();
		while(gr.next()){
			// your logic of updating here
		}
	}
	catch(ex){
		gs.info(ex);
	}
}

Regards
Ankur

[Ankur Bawiskar]

@Shashank 

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur