How to arrange list collector values in alphabetical order once the request is submitted i.e in RITM

[vijayraja]

Hi Friends,

I have a reqirement like populating 4 list collectors based on reference field. There is mapping b/w refrence field and list collector table.

Here my requiremnt is how to arrange 4 list collector values in alphabetical order.

 Variable attribute  ref_order_by is only working to show the values in alphabetical order but when it is populating it is not in order..But i need this atleast alphabtize after the request is submitted..in RITM variable editor

[Ankur Bawiskar]

Hi Vijay,

So are you saying it is showing in alphabetical order in catalog view but not in RITM view?

Regards
Ankur

[vijayraja]

Yes it is showing in alphabetical order in catalog view if we select values manually..If i am auto populating list collectors based on reference table it is not in order..I came to know that we can do that by orderBy query in script..But i need to arrange this once the request is submitted..Like i have to get autopopulate values from RITM variables and set in order 

[Harsh Vardhan]

have you written any script here to populate the list collector values ? or reference qualifier ? 

if you are using script, then you can use orderBy method in query 

https://developer.servicenow.com/dev.do#!/reference/api/madrid/server_legacy/c_GlideRecordAPI#r_Glid...

[vijayraja]

Yes it is showing in alphabetical order in catalog view if we select values manually..If i am auto populating list collectors based on reference table it is not in order..I came to know that we can do that by orderBy query in script..But i need to arrange this once the request is submitted..Like i have to get autopopulate values from RITM variables and set in order