logo

NJP

Two quick GlideRecord tips

Import · Dec 20, 2011 · article

There are some shortcuts in GlideRecord that aren't commonly used, but can save you a few keystrokes if you write a lot of scripts. Here's an example that uses four of them.

var gr = new GlideRecord("incident");gr.addActiveQuery();gr.addNullQuery("assigned_to");gr.addNotNullQuery("assignment_group");gr.addQuery("category", "hardware").addOrCondition("category", "software");gr.query();

The first, gr.addActiveQuery(), is the same as doing gr.addQuery("active", true); There is also an addInactiveQuery() method.The second, gr.addNullQuery("assigned_to"), is the same as doing gr.addQuery("assigned_to", "");The third, gr.addNotNullQuery("assignment_group"), is the same as doing gr.addQuery("assigment_group", "!=", "");The last one is a bit different. One way to include an "OR" condition that you might see in scripts is as follows:

var qc1 = gr.addQuery("category", "hardware");qc1.addOrCondition("category", "software");

This will include records in either category. The qc1 variable ends up being a QueryCondition object, which is not important to know. QueryCondition has the useful method addOrCondition() that lets you do the OR query.

But there's no need for the two lines - you can combine them like in the example above, which actually is more readable (at least to me).

View original source

https://www.servicenow.com/community/in-other-news/two-quick-gliderecord-tips/ba-p/2280937