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

[Poorna7]

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:

Variable attribute:

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

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

[Gangadhar Ravi]

Any solutions for this ? please let me know.

[Community Alums]

This is the existing know issue from ServiceNow side & it can't be fixed in the future release as well.

See the KB0695435 & PRB1256488.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=

Please mark this as correct if it answer your question.

[eviljack]

Maybe it is too late but you can also use this for example in reference qualifier:

question.question_text=your_question^ORDERBYorder

[pedrotovar]

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!