We have a gridview table with a column that has four MySQL ENUM values. The user can see all four values in the column search box as a drop-down list and they can choose any single value to search the gridview data. This is shown in the screenshot in the first column named “Billing Status”. I would like the user to be able to select one or more of the values to search. A mockup of this is shown in the second “Billing Status” column. Is this a feature built in to Yii 1.x that allows a column of the gridview to have multiple items selected? Can anyone point me in the right direction? Thank you.
I did not look into this in detail but I found this Yii Extension for 1.1
https://www.yiiframework.com/extension/echmultiselect
(scroll down to the Gridview part)
and this discussion in the forum
https://forum.yiiframework.com/t/echmultiselect-widget/47505
and a demo of the multiselect widget
https://ehynds.github.io/jquery-ui-multiselect-widget/
I hope this can help.
That is the effect that I am looking for.
I appreciate your effort and I will pass this info along to our developers.
Thank you.
Yii 1.x GridView does not support multi-select filters by default. The dropdown filter only allows a single value.
To achieve multi-select, you need to customize it:
- Replace the filter dropdown with a multi-select (e.g. Select2 or checkbox list)
- Send selected values as an array
- Modify your model’s
search()method to useINcondition (e.g.addInCondition)
This way users can filter by multiple ENUM values.
If you need a working example or Yii code, feel free to contact me:
Email: a03003132335@gmail.com
WhatsApp: +923133473749