Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Question about Variable Attributes in Reference Type Variable

Jeck Manalo
Tera Guru

Hello Everyone,


I am trying to sort the display value in my reference table into descending order.

 

latest to oldest record.

I am using variable attribute but its not able to sort of any idea how ?

 

ref_auto_completer=AJAXTableCompleter,ref_ac_order_by=number^DESC,ref_ac_columns=requested_for;location,ref_ac_columns_search=true;

1 ACCEPTED SOLUTION

Chaitanya ILCR
Mega Patron

Hi @Jeck Manalo ,

 

Looks like this order by descending order doesn't work 

I have tried different approach but still it doesn't work

 

below works when clicked on search icon but doesn't work you are intending it to

ChaitanyaILCR_0-1746500210237.png

 

found this 

https://www.servicenow.com/community/process-mining-article/reference-field-autocomplete-sort-the-li...

try this out and let me know if it works for you but it's not a good approach

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

 

View solution in original post

2 REPLIES 2

Chaitanya ILCR
Mega Patron

Hi @Jeck Manalo ,

 

Looks like this order by descending order doesn't work 

I have tried different approach but still it doesn't work

 

below works when clicked on search icon but doesn't work you are intending it to

ChaitanyaILCR_0-1746500210237.png

 

found this 

https://www.servicenow.com/community/process-mining-article/reference-field-autocomplete-sort-the-li...

try this out and let me know if it works for you but it's not a good approach

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

 

actually i already tried that adding it in reference qualifier, its shows ascending record for all record, in my case i have specific record only that i want to see in my filter.

 

Ok thank you i will check the link.