Update location field on incident

[Evan2]

Hi All

on incidents list view location is empty for many incidents. So i tried to set it as caller's location. For that I have written a background script like below to update initially a single record-

var inc = new GlideRecord('incident');
inc.addEncodedQuery('numberSTARTSWITHINC0539431');
inc.query();
while(inc.next){
inc.location=inc.caller_id.location;
inc.update();
inc.setWorkflow(false);
inc.autoSysFields(false);
}

But the request gets timed out and instance became unavailable after few minutes. So can anyone helpme how do I update location field in bulk for incidents.

Regards,

K Nandan

[Aman Kumar S]

Hey,

This is just a generic service interruption scree..

You have to wait for some time until your instance is restored.

[Evan2]

Every time I am running the query it leads to this page without updating the location to any single record.

Regards,

K Nandan

[Aman Kumar S]

Create a fix script, you can find that in the application navigator:

Paste your script in the script section

Click on "Run Fix script"

Then, click on proceed in background, it should work fine

 

[Mahesh23]

Hi,

Try below code

var inc = new GlideRecord('incident'); inc.addEncodedQuery('numberSTARTSWITHINC0539431');

inc.query();

while(inc.next()){

inc.location=inc.caller_id.location; inc.setWorkflow(false);

inc.autoSysFields(false);

inc.update();

If you want to update multiple records where location is empty you can try below code.

var inc = new GlideRecord('incident');
inc.addEncodedQuery('locationISEMPTY');

inc.query();

while(inc.next()){

inc.location=inc.caller_id.location; inc.setWorkflow(false);

inc.autoSysFields(false);

inc.update();
}

}

[Ankur Bawiskar]

Hi,

try to run for few records and verify and then run for all records

var inc = new GlideRecord('incident');
inc.addEncodedQuery('locationISEMPTY');
inc.setLimit(5); // comment this later on
inc.query();
while (inc.next()){
    inc.location = inc.caller_id.location;
    inc.setWorkflow(false);
    inc.autoSysFields(false);
    inc.update();
}

Regards
Ankur