how to use Startswith in addquery gliderecord

[chidanandadhath]

I want to query sys_db_object .. where the name starts with cmdb

[nthumma · Accepted solution]

Please see below example, Edit: Updated query

var queryString = "nameSTARTSWITHcmdb";
var gr = new GlideRecord('sys_db_object');
gr.addEncodedQuery(queryString);
gr.query();
while (gr.next()) {
   gs.addInfoMessage(gr.sys_id);
}

[Erik Gunther2]

This post is closed but I think it is more accurate to use the 'STARTSWITH' keyword in the GlideRecord query.

https://docs.servicenow.com/bundle/madrid-application-development/page/script/server-scripting/concept/c_UsingGlideRecordToQueryTables.html

[Utkars77]

You can use -

   var gr = new GlideRecord("sys_db_object");

   gr.addQuery('name' , 'STARTSWITH' , 'cmdb');