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

Question

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 1

According to the documentation:

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

Answer 2

You have a syntax error in the following code:

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

The correct way of doing this is:

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

Answer 3

class NewsController extends Controller
{

    public function actionIndex ()
    {   $news = \common\models\News::find()->orderBy(['date' => SORT_DESC])->all();
        return $this->render("index",[
            'news' => $news
        ]);
    }
}