How to sort the reference variable in DESC order in Catalog item

[Manasa Allu]

Hi team,

How to sort the reference variable in DESC order in the Catalog item.

Regards,

Manasa

[matthew_magee1]

Hi Manasa,

Try right clicking on the field>Configure Dictionary

In the Attributes field, add this attribute:

readonly_clickthrough=true,ref_ac_order_by=name

In this example, name is the field you want to order by so swap out 'name' w/ the column you want to order by

Hope this helps

[Manasa Allu]

Hi Matthew,

I have one variable in the service portal, that needs to display variable values in Descending order.

Regards,

Manasa

[GlideFather]

Hi @Manasa Allu 
of what type is that variable?

If it is a choice list, then you can just adjust the order value and make it Z-A... it if is a reference then it might be tough... 

For a reference you will need to script the reference qualifier and set the order in a script include...

[matthew_magee1]

Go into the variable and add this attribute:

When I view the variable in the portal, the names are alphabetical:

Again, swap 'name' w/ the column you want to order by

Hope this helps. Keep me posted