When I want to filter on a field that is blank (aka empty or null), there does not appear to be an option with the current list of filter operators (is exactly, is not, contains, does not contain, begins with, is one of, after, before, matches). How can I see records that "are blank" (aka empty or null)? I don't think it is currently an option. I would like to suggest that an IS BLANK option be added.
Comments
I agree. Note that this is similar to suggestion "Allow column filtering on null values".
Category: User Experience
AX doesn't support null values of table fields, but you can filter by the default value of the given type (is exactly "", is exactly 0...).
But I like the idea of having explicit "Is blank" operator, it would simplify the setup (users wouldn't have to think about particular types) and it would make the option easier to discover.
Category: User Experience
Jason Green (administrator) on 6/2/2020 9:40:36 PM
You can search for blank values today using a filter value of ""; however, this does not currently work for NULL values.