Sort by seems not working

Follow

Jellou Mae Infante

• October 25, 2021 07:19

Hi,

 

I have extracted program name, database name, number of locks on my query. And then, I would want to sort by the number of locks in descending order. However, it seems that it is not working properly. Thanks in advance for your help!

 

0

• 

  Shobhit Garg

  • October 26, 2021 09:13

  HI Jellou,

  The common reason for such issues could be that, the datatype "locks" is string or char.

  If you convert it to number before sort, then "sort" should work as expected

  https://help.sumologic.com/05Search/Search-Query-Language/Search-Operators/Manually-Casting-String-Data-to-a-Number

  | number(locks) as locks
  | sort by locks desc

   

  Regards

  0

  Comment actions Permalink

Please sign in to leave a comment.