List collector alphabetical order

[Dominik1988]

Hello!

Can you please help me solve my problem with list collector variable. I have variable list collector which display records from table "x". Problem is that I have to display all records into cataog item in alphabetical order.  It would be easy if I would have question chocies listed directly into my variable. Unfoirtunately architecture of variable is like it take records from the table "x". Maybe there is some way for sort those records into variable using "variable atributes"  ? I find something about " ref_order_by" could be inserted but don't know what exacly I should type there -  ref_order_by=true?  I would be very grateful for any help with this task.

[Vishal Birajdar]

Hi @Dominik1988 

You can use the 'field_name' from the reference table on which you want to sort the list.

ref_ac_order_by

Specifies the column that is used to sort the auto-completion list. For example, ref_ac_order_by=name sorts the auto-completion choices alphabetically by name.

Below link might help you...!!

https://docs.servicenow.com/bundle/washingtondc-servicenow-platform/page/product/service-catalog-man...