Yii2 Gridview filtering not working

Question

Can you help me out with implementing filters to GridView in Yii2? Right now, my rendered table does not respond to my actions (search GET params are not added, nothing changes if I enter a query to a filter input). Here's my code: Controller:

$searchModel = new UserSearch();
        $dataprovider = $searchModel->search(\Yii::$app->request->get());
        return $this->render('index', [
            'dataProvider' => $dataprovider,
            'searchModel' => $searchModel
        ]);

Model (UserSearch.php):

public $fullname;

    public function rules()
    {
        return [
            [['fullname'], 'safe'],
        ];
    }

    public function search($params) {
        $query = StUsers::find();
        $dataProvider = new ActiveDataProvider([
           'query' => $query,
        ]);

        if(!($this->load($params) && $this->validate())) {
            return $dataProvider;
        }

        $query->andFilterWhere(['LIKE', 'fullname', $this->fullname]);
        return $dataProvider;
    }

View:

GridView::widget([
            'dataProvider' => $dataProvider,
            'filterModel' => $searchModel,
            'columns' => [
                'id',
                'fullname'
                ],
            ]);

`$dataProvider = $searchModel->search(Yii::$app->request->queryParams);` — Insane Skull, Aug 09 '16 at 09:40
did it. But still, if I enter some text into the input and press ENTER - nothing happens (( — HugeD, Aug 09 '16 at 09:42
Have you added that column name in searchable array in modal ?? i mean safe search rules array. — Denis Bhojvani, Aug 09 '16 at 09:52
Try this [link](http://stackoverflow.com/questions/37251515/yii2-related-table-filter-and-sort) maybe it will help, it is more advanced search — Alexei, Aug 09 '16 at 10:01
I made Gii generate CRUD for me. Even now, if I put any text to filter inputs - NOTHING HAPPENS! — HugeD, Aug 09 '16 at 11:07
Open DEV window and get HTML code for any input field. Check if there are any EventListeners attached to it. — Gynteniuxas, Aug 12 '16 at 16:47

score 0 · Answer 1 · edited May 23 '17 at 11:33

0

I have the same problem when filtering in DataView. Perhaps the problem is in the client side. Check again if your jquery called twice on your page ( browser/source code ). May be your problem related with this also : jQuery(...).yiiGridView is not a function

edited May 23 '17 at 11:33

Community

1
1

answered Jan 23 '17 at 20:24

anjarwidi83

446
3
8

2

You should add a brief description of the solution, not only the link. Furthermore, if the question is already answered, you should flag the question as duplicated – Iván Rodríguez Torres Jan 23 '17 at 20:42

score 0 · Answer 2 · answered Feb 11 '21 at 12:07

There should be no need for a solution since 4 years have passed. But, problem is in next statement:

    if(!($this->load($params) && $this->validate())) {
        return $dataProvider;
    }

Change it to:

    $this->load($params);

    if (!$this->validate()) {
        return $dataProvider;
    }

Gladson Timoth · Answer 3 · 2022-08-24T12:12:33.977

0

possibly issue is jquery.min.js You should referencing not more than once Try to see if you have repeated.

edited Aug 24 '22 at 12:12

answered Aug 19 '22 at 09:49

Gladson Timoth

1
2

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Albert Logic Einstein Aug 23 '22 at 14:44

Yii2 Gridview filtering not working

3 Answers3