How to perform Filter using Multi Select Dropdown in Yii2 GridView

Question

Here i like to explain my problem clearly,

am trying to perform multi select dropdown filter, before this multiselect filter i have a basic filter.

Am using kartik-v dropdown extension

search.php

<?php
     $status = ArrayHelper::map(Status::find()->all(),'id','status');
     echo $form->field($model, 'status')->widget(Select2::classname(), [
                            'data' => $status,
                            'language' => 'en',
                            'options' => [
                            'placeholder' => 'Select Status..',
                            'multiple' => true
                            ],
                            'pluginOptions' => [
                                'allowClear' => true
                            ],
                    ]);
?>

claimsSearch.php

$query->andFilterWhere([
            'status' => $this->status
        ]);

if i try the above code am getting error as below

Array to string conversion

but here i don't know how to write filter code.

update searchview:

Where $this->status comes from? – aalgogiver Feb 18 '16 at 22:48 — aalgogiver, Feb 18 '16 at 22:48

score 4 · Accepted Answer · edited May 23 '17 at 12:02

4

Try to delete 'status' from EmployeeSearch rules. You cannot filter such field automatic way. Or you must set up custom filter value for status column, like this (you can dig into this direction):

How can I use a simple Dropdown list in the search box of GridView::widget, Yii2? Try this link

edited May 23 '17 at 12:02

Community

1
1

answered Feb 22 '16 at 05:23

Kalai S

986
3
14
25

score 1 · Answer 2 · answered Feb 15 '16 at 12:42

1

You are not calling the model in that widget. You shoudl use like this:

echo $form->field($mySearchModel, 'state_10')->widget(Select2::classname(), [
    'data' => $status,
    'options' => [
        'placeholder' => 'Select Status ...',
        'multiple' => true
    ],
]);

And your select it's probably returning an array. So, your search would be something like:

$query->andFilterWhere([
    'status' => ('in', 'status', $this->status)
]);

See more examples of queries here.

If that solution don't work, i will sugest you to do a var_dump($yourModel->status) in your view, just to check what is returning.

answered Feb 15 '16 at 12:42

Clyff

4,046
2
17
32

am getting error and same time its not showing any data in gridview(on index page) – Nodemon Feb 17 '16 at 10:42
Can you update your question with your search view and modelsearch? – Clyff Feb 18 '16 at 10:41

score 0 · Answer 3 · answered Feb 18 '16 at 14:23

$this->status is array?

So, you can use

<?php
 $status = ArrayHelper::map(Status::::model()->findAllByAttributes(array("id"=>$status));(),'id','status');
 echo $form->field($model, 'status')->widget(Select2::classname(), [
                            'data' => $status,
                            'language' => 'en',
                            'options' => [
                            'placeholder' => 'Select Status..',
                            'multiple' => true
                            ],
                            'pluginOptions' => [
                                'allowClear' => true
                            ],
                    ]);
?>

How to perform Filter using Multi Select Dropdown in Yii2 GridView

3 Answers3