5
$searchModel = new CustomersSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);

In Yii2, by default, we are provided with a searchModel and a dataProvider for the Index action. However, to customize the data returned so that it meets a specific criteria, I get a challenge. This is what I did:

$searchModel = new CustomersSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$dataProvider->query->where('customers.status = 10');

This works fine but the problem is it interferes with the filterModel of the GridView such that searching anything from the provided search filters does not work on the data returned by the GridView. Is there a where in which I can add conditions to the searchModel without affecting the filterModel in the GridView?

japheth
  • 373
  • 1
  • 10
  • 34

2 Answers2

11

If I understand correctly you want to allow users to use GridView filters but to limit the whatever results they've got to those that match customers.status = 10 condition. Is that right?

If you want not to reset the query conditions to the provided above but only to append it use andWhere like:

$dataProvider->query->andWhere('customers.status = 10');
Bizley
  • 17,392
  • 5
  • 49
  • 59
  • 1
    Yes, you got my question right. I can't believe it was this simple. Let me test your solution and see how it goes. Thanks. – japheth Aug 01 '17 at 17:42
0

See a different between where and andWhere.

If you use where, andWhere does not work. If you want to filter multiple time use andWhere

4b0
  • 21,981
  • 30
  • 95
  • 142
Abduqodir Abdumalikov
  • 11
  • 3