ENCODED QUERY
BUILDER.
Build a valid ServiceNow encoded query without guessing operators. Pick a table, stack AND/OR conditions, and copy the string straight into addEncodedQuery(), a GlideAggregate report, or a sysparm_query REST call. Everything runs in your browser — nothing is sent anywhere.
Presets
Encoded query
Paste a query from a list filter
In an instance, right-click the filter breadcrumb and choose Copy query, then paste it here to edit the conditions visually.
Copy into ServiceNow
var gr = new GlideRecord('incident');
gr.addEncodedQuery('active=true^priority=1');
gr.query();
while (gr.next()) {
gs.info(gr.getValue('number') + ' → ' + gr.getDisplayValue('state'));
}Encoded query syntax cheat sheet
^joins conditions with AND,^ORwith OR, and^NQstarts a brand new query (a true OR of two whole filters).- Dot-walk reference fields:
assignment_group.manager.active=true. - Relative dates use
javascript:—sys_created_on>=javascript:gs.daysAgoStart(7). INtakes a comma list with no spaces:state IN 1,2,3becomesstateIN1,2,3.- Prefer
addEncodedQuery()for filters copied from lists, andaddQuery()when values come from variables so they are escaped for you.
About this tool
Free · Browser-based · No signup
The SparkCoder ServiceNow Encoded Query Builder turns filter conditions into a valid sysparm_query string you can paste straight into GlideRecord, GlideAggregate, or REST calls. It is designed for ServiceNow developers, admins, and interview candidates who need to reason about queries without opening an instance.
Every condition is encoded locally in your browser — no data is sent to a server. Use the presets to see common patterns, import a query copied from a list filter, and switch between GlideRecord, GlideAggregate, and REST snippets.
Built by SparkCoder, an arcade-style practice app for ServiceNow scripting interviews.