ServiceNow: add an OR condition to GlideRecord if the initial lookup fails

add an OR condition to GlideRecord if the initial lookup fails

var queryField='number';

var rawField='INC0010001'; //--un-comment to test EQUALS

//var rawField='5'; //--un-comment to test LIKE

var tableName='incident';

var res= getReferenceFromRaw(tableName, rawField, queryField);

gs.print('result='+res);

function getReferenceFromRaw (tableName, rawField, queryField) {

// return if raw field is empty

if (rawField == '') {

return '';

}

try { //--

var grTable = new GlideRecord(tableName);

grTable.addQuery(queryField, rawField); //--EQUALS query

grTable.setLimit(1);

grTable.query();

if (grTable.next()) {

//--gs.info('EQUALS');//--not advisable to uncomment if large volume of logs written

return grTable.getUniqueValue();

} else {

//--else statement

//--see https://developer.servicenow.com/dev.do#!/reference/api/tokyo/server/c_GlideRecordScopedAPI

//-- add/applyEncodedQuery function

grTable.initialize();

grTable.addEncodedQuery(queryField + 'LIKE' + rawField); //--CONTAINS query

grTable.setLimit(1);

grTable.query();

if (grTable.next()) {

//--gs.info('CONTAINS');//--not advisable to uncomment if large volume of logs written

return grTable.getUniqueValue();

}

}

} catch (ex) {

//--gs.logError('error:'+ex.toString(),'getReferenceFromRaw');//--not advisable to uncomment if large volume of logs written

}

return;

}

ServiceNow