Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

How to change the sort order of a Lookup Select Box Variable type?

Poorna7
Tera Expert

I have created a variable of Lookup Select Box type in which  look up value field(Available Shift)is a choice type field . I have used below variable attribute but it is not showing in the correct sequence as defined in the choice field:

find_real_file.png

find_real_file.png

Variable attribute:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=office_location;date;shift_type,ref_ac_columns_search=true,ref_ac_order_by=sequence

 

find_real_file.png

 

Can someone please help how to show the timings in the dropdown sequence wise.

30 REPLIES 30

pedrotovar
Tera Contributor

Use this example as well to find active columns in the reference qualifier:

active=true^ORDERBYDESC[u_value] // Finds active fields and Sorts by descending, just use your columns name

 

I also referenced:

 

https://www.servicenow.com/community/developer-forum/lookup-select-box-reference-qual-sort-by-sequen...

 

Thread was helpful too. Good luck everyone hope it helps!