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.

[Poorna7]

no sequence is not custom field. It is the OOTB field on sys_choice table. Backend name is :sequence

[Poorna7]

 I change the order of choices and use ref_sequence=sequence but it didn't work.

I tried by changing the below sequence in the choice table but it didn't work:

[Ankur Bawiskar]

Hi,

try to add this in the Reference qualifier at the end

ORDERBYsequence

Regards
Ankur

[Poorna7]

I tried but it didn't work.

[Ankur Bawiskar]

Hi,

please update as this

+ current.variables.shift_type + '^ORDERBYsequence'

Regards
Ankur