question Re: Best practice of using addEncodedQuery in Developer forum

Best practice of using addEncodedQuery

String — Fri, 27 Jan 2023 04:48:19 GMT

Hi Team,

I'm using the below addEncodedQuery but am facing syntax error .Am trying to fetch in wrong way ?

Please guide me

var test='99894226';

var test1='TESTING';

var fieldMappingRef = new GlideRecord('asset');
fieldMappingRef.addEncodedQuery(asset_tagSTARTSWITH+'test'+^account.nameSTARTSWITH+'test1');

fieldMappingRef.query();

while (fieldMappingRef.next()) {
gs.info("enter"+fieldMappingRef.getUniqueValue());
}

Re: Best practice of using addEncodedQuery

Community Alums — Fri, 27 Jan 2023 04:54:26 GMT

Easy way is to set it up in the list view. Right click the query at the top of the list, copy the query. Paste it into your Encoded query. What you have is fine. If you want to do some trickier stuff, look up RLQuery, you can generate this by creating a report and using the SN Utils chrome extension to avoid having to save the report.

Re: Best practice of using addEncodedQuery

Anup Desai1 — Fri, 27 Jan 2023 05:00:19 GMT

Try this

var test='99894226'; var test1='TESTING'; var fieldMappingRef = new GlideRecord('asset'); fieldMappingRef.addEncodedQuery('asset_tagSTARTSWITH'+test+'^account.nameSTARTSWITH'+test1); fieldMappingRef.query(); while (fieldMappingRef.next()) { gs.info("enter"+fieldMappingRef.getUniqueValue()); }

Re: Best practice of using addEncodedQuery

GeraldKirby — Fri, 27 Jan 2023 05:02:23 GMT

addEncodedQuery accepts string as parameter. So in your query, you need to enclose it in ' ' and it would look like this

'asset_tagSTARTSWITH' + test + '^account.nameSTARTSWITH' + test1.

Your original query treats asset_tagSTARTSWITH as a variable name instead of a string. hope this helps.