I have an Ignite UI grid in an MVC application with filtering. One of my reports has a date field which can contain null/blank values. There seems to be no suitable operator for filtering these values, e.g. "Blanks only". Is there a workaround for this?
Hello cdcrowther,
I am glad that you find my information helpful.
Please let me know if you need any further assistance with this matter.
It was there in the documentation all along!
Thanks so much for your help.
Thank you for posting in our community.
What I can suggest in case that you would like to filter null values what I can suggest is setting showNullConditions option. This enables/disables visibility of null and not null filtering conditions in the dropdowns. If true, shows null and not null filtering conditions in the drop downs. Foe example:
. . features: [ { name: 'Filtering', showNullConditions : true, enabled: true, type: "local", } ] . .
.
features:
[
{
name: 'Filtering',
showNullConditions : true,
enabled: true,
type: "local",
}
]
I also created a small sample illustrating my suggestion and I am attaching it for your reference.