gr. addQuery (‘name’, ‘Joe Employee’) gr. query (myCallbackFunction) //Execute the query with callback function //After the server returns the query recordset, continue here function myCallbackFunction (gr) { while (gr. next ()) {//While the recordset contains records, iterate through them alert (gr. user_name) }}, For example, instead of addQuery(), you can also use now_GR.addEncodedQuery(‘123TEXTQUERY321= ‘). Return records from multiple tables Use the ‘123TEXTINDEXGROUP321’ reserved value to search for a string in a text index group.
function createAcl(table, role) { gs.print(Checking security on table + table) var now_ GR = new GlideRecord(sys_security_acl) now_ GR . addQuery (name, table) now_ GR . addQuery (operation, read) now_ GR .query() var encQuery = now_ GR .getEncodedQuery() if (now_ GR .next()) { // existing acl found so use it createAclRole(now_ GR .sys_id.toString(), role) return } else { now_ GR .initialize() now_ GR .applyEncodedQuery(encQuery) var acl = now_ GR.
addQuery. Once we have defined the object of a table using the GlideRecord class, we can query to retrieve the records from the table: gr.addQuery (fieldname, operator, value) // fieldname is the name of the column the table or view // operator as detailed in the table below // value is the record’s value we are looking for. Get ServiceNow …
GlideRecord Scripting — ServiceNow Elite, GlideRecord Scripting — ServiceNow Elite, The Fantastic g_form getReference Callback – ServiceNow Guru, The Fantastic g_form getReference Callback – ServiceNow Guru, While it is easy to add multiple addQuery methods to our GlideRecord object, we need to add the OR condition in one of the existing addQuery method’s object, as shown here: var gr = new GlideRecord(‘incident’) var qc = gr.addQuery(‘category’, ‘network’) qc.addOrCondition(‘category’, ‘software’) gr.addQuery(‘priority’, ‘1’), gr . addQuery (‘name’, ‘Joe Employee’) gr .query(myCallbackFunction) //Execute the query with callback function //After the server returns the query recordset, continue here function myCallbackFunction( gr ){ while ( gr .next()) { //While the recordset contains records, iterate through them alert( gr .user_name) }}, 2/24/2020 · (function() { grCI = new GlideRecord(‘cmdb_ci’) grCI. addQuery (‘sys_class_name’,’=’,’cmdb_ci_rack’) grCI.query() while (grCI.next()){ gs.log(‘CI Found: ‘+grCI.name) } })() IF STATEMENT. This will return one record, because a if statement is used to cycle through the query results. This is good if you just want to find one record, however the query would.
Encoded query strings can be copied directly from a filter, by right-clicking on the breadcrumbs. var gr = new GlideRecord (‘incident’) gr. addEncodedQuery(‘active=true^state=2’) //Encoded query gr. …
