Grid filter dropdown show blank/null and selected filter item records

[dan123Participant]

I am trying to achieve this case where on the jqxgrid i added a dropdown filter set as ‘list’ on the CompanyName column.
On the data there is record that is ‘blank/null’ on the CompanyName column. Now i want to try filtering this ‘CompanyName’ column by selecting the dropdown and click on any items. Now whatever item i select say its ‘Alfreds Futterkiste’ the grid needs to show the selected item and the ‘blank/null’ record.

So basically the filter dropdown should show the selected item and any ‘blank/null’ records. Please would like a workaround if possible

here is my jsfiddle:
http://jsfiddle.net/z6kjtr41/9/

[TodorParticipant]

Hello dan123,

Please review the following example whether it fits your needs.

Let us know if you need further assistance.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[dan123Participant]

Hi Todor,

One more thing, is there any way to hide the ‘blank/null’ item option from that column filter dropdown?

[TodorParticipant]

Hello dan123,

Please find an updated example.

Let us know if you need further assistance.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[dan123Participant]

Noticed a issue if there is a work around that would be great.

When i changed the filter dropdown placeholder set as ‘All’,

Issue 1: the grid is not showing the filter placeholder when its completely initialized.

Issue 2: When i click on the filter dropdown, i still see ‘Please Choose:’ as an item instead it should show item ‘All’ and if i select this item it is showing all ‘blank/null’ records only instead of showing all records.

Here is the jsfiddle:
http://jsfiddle.net/ofzqdkn3/1/

[TodorParticipant]

Hello dan123,

Please check this workaround.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[dan123Participant]

Hi Todor,

One concern, when i tried to add a ‘createeditor’ with a dropdownlist for cell editing on this ‘CompanyName’ column. For some reason, its freezing up the grid itself.

But i tried this on my server example, which seems to work fine. But whenever on this ‘CompanyName’ column i selected a filter like ‘Alfreds Futterkiste’ and now if i edited one of the rows in the ‘CompanyName’ column with the ‘createeditor’ dropdown say like ‘Antonio Moreno Taquera’. It refreshes the entire grid and clearing the selected filter ‘Alfreds Futterkiste’.

Here is my jsfiddle:
http://jsfiddle.net/gb4mvk3s/1/

[TodorParticipant]

Hello dan123,

The grid doesn’t refresh. If there is only one element after filtration, after the change it disappears and only the blank rows left and the filter text changes also, because there are no items with that name left. You could review this behavior in the following example. There are more than one item for “Berglunds snabbkp” company name.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[Author]

Posts