Conditionally sort query results..

[Russell Jarvis]

I'd like to sort the results of a query by column X if a value is present in field Y and sort by the value in column Z if a value isn't present in field Y.

Is this possible?

(I know how to sort query results by a single column).

Thanks, Russ

[Evgene Karachevtsev]

Hello Russell,

Unfortunately you can't do this way, only by using js. You should get the whole answer, sort,and then use

[Russell Jarvis]

Hi Evgene, thanks for your answer. Is there a bit missing?

"get the whole answer, sort,and then use..." js??

Thanks

[Evgene Karachevtsev]

Russell,

Yes, you are right. "and then use JS".

[Russell Jarvis]

thanks