Happy New Year!
Is it possible to make this order by conditional:
.with('depothourrows', depothourrowsQuery => depothourrowsQuery.orderBy('day', 'asc') )
What i want is to check if there is something in the date column and if so sort by date otherwise sort by day. I found this but i’m not sure how to do this:
order by CASE WHEN date date ELSE day END
I guess i’ll have to use a raw query?