GlideRecord Reference Sheet

Examples only

Query Active Incidents

var inc = new GlideRecord('incident');
inc.addQuery('active', true);
inc.query();
while(inc.next()) {
	gs.log('Number is ' + inc.number);
}

Query Using Get

var inc = new GlideRecord('incident');
inc.get('sys_id'); //sys_id of specific record
gs.log('Number is ' + inc.number);

Insert Record

var inc = new GlideRecord('incident');
inc.initialize();
inc.short_description = 'This is a new incident created by GlideRecord Script';
inc.description = 'This is pretty awesome';
inc.insert();

Delete Multiple

var inc = new GlideRecord('incident');
inc.addQuery('active', false);
inc.deleteMultiple();

Encoded Query

var inc = new GlideRecord('incident');
inc.addEncodedQuery('state=1^assignment_group!=NULL'); //Encoded query
inc.query();
while(inc.next()) {
	gs.log('Number is ' + inc.number);
}

Get Row Count

var inc = new GlideRecord('incident');
inc.addQuery('active', 'true');
inc.query();
gs.log(inc.getRowCount() + " active Incidents");

Set Limit

var inc = new GlideRecord('incident');
inc.addQuery('active', 'true');
inc.setLimit(5);
inc.query();
while(inc.next()) {
	gs.log('Number is ' + inc.number);
}

orderBy / orderByDesc

var inc = new GlideRecord('incident');
inc.addQuery('active', true);
inc.orderBy('number'); 
//inc.orderByDesc('number'); 
inc.query();
while(inc.next()) {
	gs.log('Number is ' + inc.number);
}