Forum | Appery.io

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

Hello Russell,

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

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

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

Thanks

Russell,

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

thanks