How can I sort a filter with both ascending and descending arguments

J G_txdejj

edited

NEVERMIND. I found my answer. Sorry for posting such a basic question.

 

I have a filter that returns the results I need, but I need the results in a specific order. To achieve this I have to sort column 1 & 2 in Descending format and then sort by column 3 in Ascending format.

I see how to sort columns 1&2 using [Order By "column1","column2" DESC] but I cannot figure out how to add column 3 ASC.

Thanks

JG

Jack Brickey

something like this....

project = xxx AND created >= startOfYear(120d) ORDER BY updated DESC, assignee ASC, status DESC