$query, 'pagination' => [ 'pageSize' => 5 ], 'sort' => [ 'attributes' => [ 'id', 'name', 'path', 'params', 'active', 'hide_min', 'parentt' => [ 'asc' => ['name' => SORT_ASC], 'desc' => ['name' => SORT_DESC], 'default' => SORT_DESC ] ] ] ]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere([ 'id' => $this->id, 'parent_id' => $this->parent_id, 'active' => $this->active, 'hide_min' => $this->hide_min, 'sort' => $this->sort ]); $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['like', 'path', $this->path]) ->andFilterWhere(['like', 'params', $this->params]) ->andFilterWhere(['in', 'parent_id', $this->find()->select(['id'])->andFilterWhere(['like', 'name', $this->parentt])->column()]); return $dataProvider; } }