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
Kilo 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
Kilo 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.