Variable value show based on order

[Ramjee]

I have a requirement to display records from a custom table in a specific sequence (based on defined order) instead of the default alphabetical order in a type of lookup select box variable.

Please help with the appropriate approach to achieve this.

Thank you 

Ramji

[Tanushree Maiti]

Hi @Ramjee 

If you have lookup select box called 'u_var', then use the following reference qualifier: "ORDERBYu_var" in the type specification.

[Ramjee]

Hi @Tanushree Maiti , 

Thank you for the quick response. I tried the suggested approach, but it is not working on my end.

[KanteS]

Hi 

U can try  Attributes: order_by=uvar or try advanced reference qualifier 

[Tanushree Maiti]

Hi @Ramjee 

I double checked , For us with Custom table , its working fine. Make sure you have selected your look up  value field properly .