Last Updated: 10 Oct 2017 19:12 by Frank
Created on: 28 Nov 2012 23:39
Category: Grid
Type: Feature Request
Allow users to search in the grid for NULL/ NOT NULL values
The grid has a number of built in filters, what is not supported is searching for cells that have no value or some value (i.e. NULL or NOT NULL).
This would be a very useful addition.
Posted on: 10 Oct 2017 19:12
This doesn't work on boolean columns. We have data that supports true/false/null, and we can only get true and false to work. If we try and include a null filter option, the grid filter just assume false and null are the same. See support ticket,, for details. I'd expect this feature to work for all column types.
Posted on: 16 Feb 2017 14:32
unable to filter with null values in kendo grid...When can we expect this feature
Telerik Admin
Posted on: 13 Jan 2016 17:51
Shipped in Q1 2016
Telerik Admin
Posted on: 07 Jan 2016 17:19
The feature is already available in our Q1 Beta, and will go official next week with Q1 RTM. We'll also introduce IsEmpty/IsNotEmpty filtering options.
Posted on: 05 Jan 2016 15:59
I was surprised to find out that this feature was not standard. This should be a high priority add to the next release.
Telerik Admin
Posted on: 19 Aug 2015 08:14
We'll do everything possible to include it, but we cannot make a definite commitment at this point, Jasen.
Posted on: 18 Aug 2015 15:59
Is this definitely being included by the end of the year? This functionality is a deal-breaker for us, and if it isn't going to be available, then we need to find a different solution.
Telerik Admin
Posted on: 17 Jul 2015 08:42
This feature will be taken into consideration after the Q3 release, and we'll do everything possible to deliver it by the end of the year.
Posted on: 15 Jul 2015 22:16
we need this feature ASAP. Thank you.
Posted on: 15 Jul 2015 17:29
The KendoUI Q3 Roadmap was just announced and the #1 most-voted-on suggestion is still marked as 'Under Review' (since May of last year).  It's beyond frustrating -- can you give us anything more specific than "It will be pondered in the second half of 2015"?
Imported User
Posted on: 26 Jun 2015 15:16
We need this for our data reporting.  Please add.
Posted on: 09 Jun 2015 12:45
that's a must!! please add this 
Posted on: 08 Jun 2015 17:54
This should be the very basic and mandatory feature to be available in Kendo. It will be great if we get this soon..
Posted on: 01 Jun 2015 19:09
I have just found that I need this feature for client side filtering. Non-blank. Let get this thing rolling.
Telerik Admin
Posted on: 13 May 2015 09:28
Thanks for expressing your continuous interest in this feature, folks. It will be pondered in the second half of 2015.
Posted on: 12 May 2015 12:32
Please we need it !!! 475 votes is not enough?
Posted on: 07 May 2015 14:18
I would be eternally thankful (in my heart not in my pocket) for the addition of null filters.
Imported User
Posted on: 05 May 2015 07:16
We are need it!!!!
Posted on: 17 Feb 2015 15:20
The most annoying issue in the grid.
Telerik Admin
Posted on: 05 Feb 2015 08:41
This feature will be considered for an upcoming Kendo UI release, post Q1 2015. Stand by for updates later in the year, folks.
Imported User
Posted on: 04 Feb 2015 16:28
We need it.  Otherwise we have to create custom views just for blanks or nulls.
Posted on: 03 Feb 2015 18:41
Any traction on this?!  I get nagged on a consistent basis that this functionality isn't present in our site.  Love the grid component, but this is a big hole in functionality.
Posted on: 25 Jan 2015 19:35
I was surprised to see this feature not there! Re-creating Dynamics CRM like grids and need this feature.
Posted on: 02 Dec 2014 15:53
Add me to the list of people requesting this feature - just got a request from our product owner that users want this functionality in our applications.
Mitch Thraves
Posted on: 24 Nov 2014 11:09
Back in April 2013 I got this response from the Kendo team.

"Unfortunately this [Filtering blanks/nulls] isn't something trivial and is not an often required feature. In fact, across all of my years here at Telerik I have yet to hear about a request to filter by blank entries across any one of our UI component suites."

At the time I was astounded. However, over the last 12 months it's somewhat reassuring to see so many people are now asking for this as my clients have been complaining about this missing functionality for ages.
Posted on: 24 Nov 2014 03:49
Hi Guys, This is something that we also require, it would be very useful for us.
Posted on: 23 Nov 2014 21:24
Have just run into a problem specifically because the grid doesn't support this. Really really want to see it in the near future!
Posted on: 18 Nov 2014 08:26
Please add this filtering functionality - it's an absolute necessity.
Posted on: 27 Oct 2014 15:00
standard filtering is limited with out being able to filter on null/not null and empty/not empty. 
Posted on: 15 Oct 2014 03:03
Trying to migrate from RadGrid to Kendo and this is a MAJOR omission - it really is a very common ( and necessary) feature and should definitely be added as a standard feature to the Kendo grid.
Telerik Admin
Posted on: 01 Oct 2014 09:08
I don't think there's a suitable workaround other than your own custom implementation, Radha. I will try to raise the priority of this feature for future Kendo UI releases.
Radha Krishnan
Posted on: 01 Oct 2014 07:30
Kenshin, Is there a workaround or alternative way to achieve this.?
Posted on: 29 Sep 2014 16:10
Being able to filter on null values is fundamental for many use cases. Its very disappointing to find the grid does not allow this
Jaume Aguilo
Posted on: 05 May 2014 12:37
How many versions have kendoUI already launched? I can't believe this functionality is still not available !!. This is something really needed.
Telerik Admin
Posted on: 01 May 2014 16:55
This feature is on our radar, Nitin, and will eventually be discussed and planned some time after Q2 2014.
Posted on: 25 Apr 2014 18:26
i wonder how many votes u guys needed to add this? isn't a common sense to add this feature - if u r building a professional tool...or u guys not capable to add this feature?
Posted on: 14 Feb 2014 20:13
I would love to see this feature make it into a release.  Requests to filter for entities with empty attributes comes up often
Posted on: 06 Nov 2013 14:55
This functionality should be essential feature of Kendo grid. We really need this feature.
Posted on: 21 Oct 2013 12:09
I think, this functionality is required in most cases So it should be filtered either null or not null 
Posted on: 09 Sep 2013 15:11
This feature is "must have", especially search for NULLs. While search for NOT NULL can be workarounded sometimes, e.g. Dates, numbers.
Posted on: 31 Jul 2013 07:33
I think this functionality is required for most of the scenarios. Anyhow, I've acheived Blank filtering by making some changes in server side dyanmic query and client side functions.
Posted on: 26 Jul 2013 05:29
How many votes are required to include this functionality ?
Imported User
Posted on: 25 Jul 2013 20:28
This is a critical need for our implementation.  The users need the ability to find specific fields which need to be populated and the inability to search on blanks with the toolkit is causing us to have to consider alternative solutions.
Posted on: 25 Mar 2013 02:14
What is needed is a way to easily search all columns all data on the client or on the server. A demo or a built in addition would be great.
Mitch Thraves
Posted on: 11 Mar 2013 15:23
This is an essential feature for us. Can you please add this capability as soon as possible.