Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
Kilo Patron
Kilo Patron

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.