question Re: Need to sort choices by Sequence in Catalog Client Script in ITSM forum

Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Thu, 07 Dec 2017 22:54:26 GMT

Hi All,

I'm having an issue with a Catalog Client Script. I'm using a template provided by another user in this forum (Pradeep Sharma) which does exactly what I want except it does not order by sequence. I can't seem to get "sort" to work so I am looking for suggestions.

Here is the basic script I am using:

function onChange(control, oldValue, newValue, isLoading) {
         if (isLoading || newValue == '') {
               return;
       }
       //remove all items from appropriate Access Level drop down to start
       g_form.clearOptions('u_access_level_1');
       
       var app = g_form.getReference('u_application');
       //build a new list of dependent options
               var gpSub = new GlideRecord('sys_choice');
       gpSub.addQuery('table','sc_request');
       gpSub.addQuery('dependent_value', app.name);
       gpSub.addQuery('element', 'u_access_level_1');
       gpSub.query(function(gpSub){
               while(gpSub.next()){
                       g_form.addOption('u_access_level_1', gpSub.value, gpSub.label, gpSub.sequence);
                       
               }
               
       });
}

What am I doing wrong? What would I need to do to correct it? Bonus points if it can be corrected without using an array (trying to stick with an SOP here).

Thanks in advance! Happy to grant Likes and Correct Answer designations.

Regards,

Robert

Re: Need to sort choices by Sequence in Catalog Client Script

Bryan Tay3 — Thu, 07 Dec 2017 23:21:16 GMT

hi Robert,

try add following between line 14 and 15.

gpSub.orderBy('sequence');

Hope this helps.

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 08 Dec 2017 00:17:38 GMT

I had wanted to try orderBy as I know it from SQL, but never did. Was using javascript "sort" (ineffectively).

I tried "gpSub.orderBy('sequence');" (and a couple of variations), but no-go. It still sorts by sys_created_on.

Any other ideas?

Thanks,

Robert

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 08 Dec 2017 00:24:15 GMT

I just tried it with "gpSub.orderByDesc('sequence');" That works!

Wouldn't have found it without your help, so I'm giving you a Like and a Helpful. Don't want to mark it as Correct and mislead folks...

Cheers!

Robert

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 08 Dec 2017 00:49:19 GMT

I stand corrected...after more extensive testing, "gpSub.orderByDesc('sequence');" doesn't work either. 😞

Any other bright ideas?

Thanks,

Robert

Re: Need to sort choices by Sequence in Catalog Client Script

Bryan Tay3 — Fri, 08 Dec 2017 00:59:05 GMT

hi Robert,

Perhaps this may help?

orderByDesc or orderBy does not work in Client Script onChange

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 08 Dec 2017 01:02:20 GMT

Yeah...I read that one (which is where I found the "orderByDesc"), but it basically came down to "I think the problem is somewhere else in your script." No help. 😞

Thanks anyhow...

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 08 Dec 2017 01:10:53 GMT

Though a link in there has good info: https://www.servicenowguru.com/scripting/gliderecord-query-cheat-sheet/

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 08 Dec 2017 01:15:05 GMT

I stand corrected. Your first suggestion did work (gpSub.orderBy('sequence');). I was just using different test data between instances.

Marking your answer as Correct!

Thank you!

Re: Need to sort choices by Sequence in Catalog Client Script

Shiri — Thu, 16 Jan 2020 19:01:55 GMT

I don't see the numbers in the lines. Can you please indicate which ones are lines 14 & 15?

Where did you enter the sort?

Re: Need to sort choices by Sequence in Catalog Client Script

Robert_Cartwrig — Fri, 17 Jan 2020 00:10:57 GMT

Hi Shiri,

You can add it in anywhere between the GlideRecord and the Query.

Regards,

Robert