Orderby for look up select box

servicenow14710
Tera Expert

Hello developers, i have a scenario where a variable which is lookup select box loading the custom table records needs to sorted by order.

Here is order is a column("u_order" which is integer) in that custom table . so based on u_order the list records has to be sorted .

In variable attributes of the field i gave ref_ac_order_by=u_order which is not workn . can anyone know what the issue here is. Any help is appreciated. Thanks.

9 REPLIES 9

J Siva
Tera Sage

Hi @servicenow14710 
In the reference qualifier add the below and see.

ORDERBYu_order

JSiva_0-1744112603827.png

 

Regards,
Siva

 

Hello @J Siva : I used this as well it didnt work, Thanks for your response

Could you please share the snap of variable configuration?
I tried below and it worked.

JSiva_0-1744113369626.pngJSiva_1-1744113410750.pngJSiva_2-1744113440768.png


Regards,
Siva

Hello @J Siva :Thanks for your response but  I have a query returning from script include need to add this in a function called in script include.