Query Operators

These operators are used across all ServiceNow query APIs to filter and retrieve records. They work consistently whether you're using:

• GlideRecord – The standard server-side API for database operations
• GlideRecordSecure – GlideRecord with ACL enforcement
• GlideQuery – The modern, expressive alternative to GlideRecord
• GlideAggregate – For database aggregation queries (COUNT, SUM, MIN, MAX, AVG)

Using Operators

In GlideRecord & GlideRecordSecure

Use operators with addQuery() or addEncodedQuery():

var gr = new GlideRecord('incident');
gr.addQuery('priority', '<=', 2);
gr.addQuery('state', 'IN', '1,2');
gr.query();

In GlideQuery

Pass operators as the second argument in where():

new GlideQuery('incident')
  .where('priority', '<=', 2)
  .where('state', 'IN', [1, 2])
  .select();

In GlideAggregate

Operators work the same as GlideRecord:

var ga = new GlideAggregate('incident');
ga.addQuery('priority', '<=', 2);
ga.addAggregate('COUNT');
ga.query();

Operator Reference