Getting Records Before X Days

[kaustubh vishnu]

#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=requested^sysapproval.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'));
}