Cannot filter on undefined (NULL) values

ipwizard · Post by **ipwizard** » Sat Sep 23, 2023 12:04 am

Hi, I am using ASP.NET Maker v2023.5.

I have a page with several columns of data, and some of the fields are allowed to be null. I want to filter the results showing all the nulls. When I drop down the filter funnel, I see an option "undefined," which I assume was for showing the null/empty fields, but I am unable to click on the check box for this option. The other values that show up in the filter dropdown box work as they should. On the list page configuration for the table, all of the rows have the filter option checked.

Any help is appreciated.

MichaelG · Post by **MichaelG** » Sat Sep 23, 2023 9:05 am

Filter probably does not support null value. Avoid null value in your data or use extended filter instead.

ipwizard · Post by **ipwizard** » Tue Sep 26, 2023 12:03 am

Makes sense. I thought it worked earlier when I was creating the project. Anyway I will remove the nulls.

Thanks