Reference Field : How to sort the results in descending order using reference qualifier?

kutvaram
Tera Expert

Hi All,

I have a variable of reference field type with simple condition in it.

I need to sort the results by a column in descending order.

I used variable attributes section where ref_ac_order_by=columnname.

This is doing ascending order sorting.

How to do it descending order sorting by a column name?

I have referred many community links and also got to know , have to write query business rule. But I am not happy with that.

Kindly advise using variable attributes sorting by descending or a better way.

Thanks,

Ram Prakash K R

1 ACCEPTED SOLUTION

Can you try like this

var encodedquery = "sys_created_on>=2020-12-14^sys_created_on<=2020-12-15 23:59:59";

Thanks,

Narsing

View solution in original post

22 REPLIES 22

Hi,

Try setting Isolate Script field for your client script as False

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur,

I did it but the result is "no matches found".

Kindly advise.

Thanks,

Ram Prakash K R

Hi,

Not sure from the client script approach.

will have to check

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi,

I just tried from the client script which is shared and seems not working in native view

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Narsing,

Can you please check my code and let me know what I am doing wrong here, if its working for you?

Thanks,

Ram Prakash K R