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.

[Ankur Bawiskar]

Hi,

try to add this in the Reference qualifier at the end

ORDERBYsequence

Below configuration worked for me

Regards
Ankur

[hammad ul aziz2]

@Akansha 

       try 

AJAXTableCompleter,ref_ac_columns=office_location;date;shift_type,ref_ac_columns_search=true,ref_sequence=sequence 

instead of ref_ac_order_by=sequence, let me know if that works!!

[Poorna7]

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

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

[hammad ul aziz2]

is sequence a custom field?

whats the backend name of sequence field can you confirm that please.

[Poorna7]

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