Need filter lookup choice variable values based on order on portal

[ruchitha4]

I have look up select box variable referring from sys_choice table. I need to display the options based on sequence field from sys_choice table instead of displaying options alphabetically. I need to display the Other option at the end but not able to doo so even with reference qualifier condition as given below. Please help.

javascript:'name=incident^sequence!=0^ORDERBYsequence^element=category^inactive=false^language=en^dependent_value=' + current.variables.u_business

[Bhavya11]

Hi @ruchitha4 

i just looked into the reference qualifier condition in that you have add  like 'sequence!=0' then the choices with nothing means empty in sequence wont come in the drop-down.

if you removed the 'sequence!=0' from the condition then in drop- down with empty sequence will add first followed by order of sequence.

so please make sure that you have to add the sequence to choices.

If my response proves useful, please indicate its helpfulness by selecting " Helpful." 

Thanks,

BK