kumar_v kumar_v - 5 months ago 12
PHP Question

Yii2: How to add two fields in orderby() of Find()

How to add more than one field to sort in find() method?

I have tried as below

$model::find()->orderBy([['id_date' => SORT_DESC],['item_no'=>SORT_ASC]);


But it is throwing error with query.
Orderby Query produced by yii2 is:
ORDER BY 0, 1

Answer

Regarding to the documentation:

$model::find()->orderBy([
  'id_date' => SORT_DESC,
  'item_no'=>SORT_ASC
]);