question GlideQuery .select(Fields) is not working as expected in Developer forum

GlideQuery .select(Fields) is not working as expected

Surya_Prakash — Fri, 27 Sep 2024 12:53:44 GMT

Hi All,

I have a requirement where I'm passing set of sys_id's in a order to get some fields using the GlideQuery.select(Fields) method.

My expected output was to get the result in same order of the sys_id I'm passing in the query, but the code is returning data's based on some other order.

Sample code:

var sysID = {1,2.3,....100};

var selectedFields = [a,b,c,d];

var gq = GlideQuery(table);

gq = gq.where('sys_idIN' + sysID);//Till here the code was going on the same order as the sysid I passed.

gq = gq.select(selectedFields);

gs.info("ANS: " + gq); //Here the sysid is getting mixed up and showing data on some random order

Is it possible to get the output also in the same order of sys_id which was passed in the script?

Thanks,

Surya. P

Re: GlideQuery .select(Fields) is not working as expected

Rajesh Chopade1 — Fri, 27 Sep 2024 13:04:15 GMT

hi @Surya_Prakash

Try bellow script and check once:

i hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.

thank you

rajesh

Re: GlideQuery .select(Fields) is not working as expected

Surya_Prakash — Fri, 27 Sep 2024 14:01:37 GMT

Hi @Rajesh Chopade1,

Thanks for the reply. Currently I'm getting the code in below format. Can you please help to just fetch the sysid's (Value) from the code.

GlideQuery<tablename> [
{
"type": "where",
"field": "sys_id",
"operator": "IN",
"value": [
"sysid 1",
"sysid 2",
"sysid 3"

]

Thanks,

Surya. P

Re: GlideQuery .select(Fields) is not working as expected

Rajesh Chopade1 — Fri, 27 Sep 2024 14:11:18 GMT

hi @Surya_Prakash

Here you just simply focus on fetching the values from the "value" array.

Assuming you have input in a variable, you can use following code.

// Assuming this is your input data structure var input = { "type": "where", "field": "sys_id", "operator": "IN", "value": [ "sysid 1", "sysid 2", "sysid 3" ] }; // Extracting sys_ids var sysIds = input.value; gs.info("Extracted sys_ids: " + sysIds.join(", ")); // output : Extracted sys_ids: sysid 1, sysid 2, sysid 3 //If you want to use these sys_id values in a GlideQuery for further operations, you can use the IN operator var gq = new GlideQuery('tablename'); gq = gq.where('sys_id', 'IN', sysIds); gq.select('sys_id'); // or any other fields you want

Re: GlideQuery .select(Fields) is not working as expected

Bert_c1 — Fri, 27 Sep 2024 14:16:23 GMT

Please review: GlideQueryCondition API

If you want your code to work.

Re: GlideQuery .select(Fields) is not working as expected

Surya_Prakash — Fri, 27 Sep 2024 14:24:27 GMT

No luck, it is showing "undefined" as the output when I'm fetching Value from the code.

Note: This is not a payload, it was the data fetched using another glide query line.

ex: glidequery.where(Parameter[field], Parameter[operator], Parameter[value]);

Re: GlideQuery .select(Fields) is not working as expected

Surya_Prakash — Mon, 30 Sep 2024 05:50:13 GMT

Hi @Rajesh Chopade1,

Thanks for your reply, this was the solution I expected and with some minor changes to my code I was able to achieve the output.

Thanks,

Surya. P