Scheduled Job

[yoli1]

Hello team how can i create a Scheduled job script on the table Incident with filter : active is true and approval is not requested and location is empty 

to Set country to location.country

[Saurabh Gupta]

Hi,
Schedule job is independent of any table.
You can execute the script of your choice within the schedule job.

[yoli1]

@Saurabh Gupta  is my Scheduled Scrip correct ?

(function () {
    var gr = new GlideRecord('incident');
    gr.addQuery('approvam', '!=', 'requested');
gr.addQuery('location', '');
    gr.query();

    while (gr.next()) {
        gr.location = location.country;
        gr.update();
    }
})();

[Community Alums]

Hi,

try the below script 

   var gr = new GlideRecord('incident');
    gr.addEncodedQuery('active=true^approval!=requested^locationISEMPTY');
    gr.query();
    while (gr.next()) {
        gr.location = location.country;
        gr.update();
    }

Thanks,

Vikas

[yoli1]

@Community Alums i want 

gr.region = location.country;

but i have an error : location not defined should i do

gr.region = gr.location.country;

?