How to sort (a-z) names in variable with user last name

Nirav
Tera Expert

Hi,

 

We have a  "requested_for" variable on portal catalog item which is referencing user table (attached screenshot).

I want the list to be populated/sorted (a-z) by last name. Is there anyway we can do this? would appreciate your help.

requestedfor1.pngfilter 4.png

 

Thanks,

Nirav

1 ACCEPTED SOLUTION

Claude DAmico
Kilo Sage

Add a variable attribute for ref_ac_order_by=last_name.

 

https://docs.servicenow.com/bundle/tokyo-servicenow-platform/page/product/service-catalog-management... 

Claude E. D'Amico, III - CSA

View solution in original post

4 REPLIES 4

Claude DAmico
Kilo Sage

Add a variable attribute for ref_ac_order_by=last_name.

 

https://docs.servicenow.com/bundle/tokyo-servicenow-platform/page/product/service-catalog-management... 

Claude E. D'Amico, III - CSA

how to set order by (z-a)

Nirav
Tera Expert

 

It is working. Thanks Claude for the quick help.

Excellent! I'm glad I could be helpful!

Claude E. D'Amico, III - CSA