1 Usecase : Getting Records Before X Days

var gr = new GlideRecord("sysapproval_approver");gr.addQuery('state','requested');gr.addEncodedQuery('sysapproval.numberLIKERITM');

gr.addQuery('sys_created_on','>',gs.daysAgo(10));

gr.query();

var total = gr.getRowCount();

gs.log('total row filtered :- ' +total);

while(gr.next()){

gs.log('ritm number is ' +gr.getDisplayValue('sysapproval'));

}

# 2 Usecase : Updating Record's Field Value using Backgroud Script

var gr = new GlideRecord('sysapproval_approver');gr.addEncodedQuery('state=requestedsysapproval.numberLIKERITM0067461');gr.query();while (gr.next()) {gr.sys_created_on = '2022-01-30';gr.setWorkflow(false);gr.update();

}

# 3 Usecase: Creating Incident with old date using background script

var gr = new GlideRecord('incident');gr.initialize();

gr.opened_at = '2022-03-17 17:02:44';

gr.setWorkflow(false);gr.caller_id = 'amit.lode';gr.category = 'Network';

gr.subcategory = 'Wireless'; // check mandatory and auto updating fields first.

gr.insert();

# 4 Usecase : Deleting records : Limit records : Bulk Deleting

var gr = new GlideRecord("sys_user_group");gr.addEncodedQuery('sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()');gr.setLimit(2);

gr.query();

var total = gr.getRowCount();

gs.log('total row filtered :- ' +total);

while(gr.next()){gr.setWorkflow(false);

//gr.deleteMultiple();

//gr.deleteRecord();

gs.log('group name is ' +gr.getDisplayValue('name'));

}

Labels: