how to add order by in the existing encoded query

[Priyanka Shind1]

Hello All,

I have used below encoded query and I want to add order by on opened_at field which is a date field.

At present it is showing old to new records however I want to showcase new to old records.

Below is my encoded query copied from incident table

caller_idDYNAMIC90d1921e5f510100a9ad2572f2b477fe^opened_atONLast6months@javascript:gs.beginningOfLast6Months()@javascript:gs.endOfLast6Months()^EQ

Thank you in advance.

Regards,

Priyanka Shinde

[Shakeel Shaik · Accepted solution]

Hi Priyanka

ORDERBYDESC = New to Old

caller_idDYNAMIC90d1921e5f510100a9ad2572f2b477fe^opened_atONLast6months@javascript:gs.beginningOfLast6Months()@javascript:gs.endOfLast6Months()^EQ^ORDERBYDESCopened_at

[chsumit]

Hi,

You can add reqs.orderBy(''); after your encoded query.

Thanks,

Sumit