yii2 gridview filter with custom value

Question

I have displayed the values as follows :

1 => "Active", 0 => "Inactive"

1,0 are the db values.

This is my column.

[
            'label' => 'Status',
            'attribute' => 'activeStatus',
            'format' => 'html',
            'value'=>function ($data){return $data->activeStatus ? '<span class="label label-success">Active</span>' : '<span class="label label-danger">Inactive</span>';} 
        ],

How to enable grid filter with Active/Inactive? It can be a dropdownlist or just by typing Active/Inactive.

My db has int value, I display the values like 1 => "Active", 0 => "Inactive", it's not filtering. — Dev
– Dev, Commented Apr 6, 2018 at 6:28
Just add that array with the 'filter' => ... key and make sure that activeStatus attribute is on the rules() list in the model used for searching. — Bizley
– Bizley, Commented Apr 6, 2018 at 6:50

Insane Skull · Accepted Answer · 2018-04-06 06:54:58Z

1

GridView

[
    'label' => 'Status',
    'attribute' => 'activeStatus',
    'format' => 'html',
    'value' => function ($data){
        return $data->activeStatus ? '<span class="label label-success">Active</span>' : '<span class="label label-danger">Inactive</span>';
    },
    'filter' => [1 => 'Active', 0 => 'Inactive'],
],

SearchModel

public function rules()
{
    return [
        [['activeStatus'], 'integer'],
        .
        .
        .
    ];
}

// grid filtering conditions
$query->andFilterWhere([
     'activeStatus' => $this->activeStatus,
]);

answered Apr 6, 2018 at 6:54

Insane Skull

9,3619 gold badges49 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dev Over a year ago

Values passing correctly in the url. But it doesn't return values :(

Insane Skull Over a year ago

@BeginnerDev Check your searchModel's filter condition and rules.

Collectives™ on Stack Overflow

yii2 gridview filter with custom value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related