List Collector Variable Sorting Order

[chandukollapart]

Hi,

Is there a way to sort List collector variable options. Currently it is displaying based on displayed field on that table but we would like to change that one.

Tried ORDERBYsequence and also ref_ac_order_by=sequence but none of them is working.

Any suggestion!

Thanks

[Community Alums]

Hi @chandukollapart ,

You can use before query business rule, where you can make use of "ORDERBY". 

Refer to the link : https://servicenowguru.com/client-scripts-scripting/changing-filter-list-collector-variable-client-s...

Also, "ref_ac_order_by" works well with Reference Field type mostly and on Service portal.

[Thinh Nguyen1]

Use "ref_ac_order_by=sequence" in Variable attributes, it works for me