[Solved] How can I filter a grid to only show records that have no data in a column?

[Matthew]

I have a grid in my app that's filterable, but for one of my columns I need a way for the user to tell the grid to only filter by records that have nothing in that column.  I can't seem to find a way to do this, as the filters seem to be based on data that is in the field, but nothing relating to when no data is in the field.

Thanks,

[Atanas Korchev]

Hello Matthew,

 Currently the grid filtering UI does not support empty value filtering (or null filtering). You can use the server side api to filter the grid

.Filterable(filtering => filtering
            .Filters(filters => filters
                .Add(o => o.Customer.ContactName).IsEqualTo("")
        ))

or bind the grid to a prefiltered datasource.

Regards,
Atanas Korchev
the Telerik team