ServiceNow variable advanced reference qualifier example
***************
script incl funcs:
getHRRefQual: function(refQualID){
//--build up ref quals
var sRefQualQuery="";
if (refQualID=='hr_openedfor_returner'){
//--called from here: /nav_to.do?uri=item_option_new.do?sys_id=271a5f781b766f00cee5ed7cee4bcb60
//sRefQualQuery="nameISNOTEMPTY^u_technical_user=false^" + this._DormantAccountUsers();
sRefQualQuery=this._DormantAccountUsers();
}
return sRefQualQuery;
},
_DormantAccountUsers: function(){
//--use below to query dormant accounts table
var grDorm=new GlideRecord('u_dormant_accounts');
var sQuery='u_user.nameISNOTEMPTY^u_user.u_technical_user=false^u_user.last_login_time<javascript:gs.beginningOfLast3Months()^ORu_user.last_login_timeISEMPTY';
grDorm.addQuery(sQuery);
//grDorm.addQuery('u_user.active=false');
grDorm.addNotNullQuery('u_user');
grDorm.query();
//gs.print('Active users, dormant accounts table: ' + grDorm.getRowCount());
var dormUsersSYSIDs='';
while (grDorm.next()){
dormUsersSYSIDs+=grDorm.u_user.sys_id;
dormUsersSYSIDs+=',';
}
var dormUsersFormatted = dormUsersSYSIDs.substr(0, dormUsersSYSIDs.length-1); //--remove the final ,
return dormUsersFormatted;
},
This comment has been removed by the author.
ReplyDeleteYou've written a very useful article about import export data provider. This article provided me with some useful knowledge. Thank you for providing this information. Keep up the good work.
ReplyDeleteThis example clearly shows how a ServiceNow variable reference qualifier can dynamically build a sys_idIN condition by calling a Script Include function. The getHRRefQual() method selects the appropriate reference-qualifier logic, while _DormantAccountUsers() queries the dormant accounts table and collects the related user sys_ids.
ReplyDeleteThe use of a reusable Script Include is particularly useful here because the reference qualifier does not need to contain the complete database logic itself. The approach also demonstrates how JavaScript can assemble encoded queries and process GlideRecord results, which makes a Javascript Course in Chennai relevant for understanding the scripting patterns used in the example.
The final comma-separated sys_id list is then returned and appended to sys_idIN, allowing the variable to restrict its reference choices to the users identified by the custom logic. Developers working with ServiceNow configurations can build similar reusable scripts through Javascript Training in Chennai.
ReplyDelete