How can I implement the following (sql) sorting in Yii2:
SELECT * FROM orders order by case when status != ‘ORDER_DONE’ then 1 else 2 end,status
I want to drop statuses with ORDER_DONE to the bottom. Any idea?
How can I implement the following (sql) sorting in Yii2:
SELECT * FROM orders order by case when status != ‘ORDER_DONE’ then 1 else 2 end,status
I want to drop statuses with ORDER_DONE to the bottom. Any idea?
Assuming the SQL is valid: What part of the implementation are you struggling with? Are you familiar with the Query / ActiveQuery classes?