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.

[Mike Patel]

If you just change variable to reference type then below should work. I don't think it will work on lookup select box.

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

[Poorna7]

If I change type to reference then how should I build the reference qualifier, I mean how it will look up for available windows.

[hammad ul aziz2]

keep the order for first choice as 100 and for second 200. it will work

let me know if that works,

please mark this as correct and helpful if this helps you in anyway.

[Poorna7]

I tried but it didn't work.