Imported items without a field value no longer appear in view with filters on that field

We’ve been importing invoices via email integration. The email entity contains a date field for “Invoice Date”. On the main view for viewing invoices, there’s a filter to only show entities with invoice dates within the past 2 months. It used to be that imported emails without the Invoice Date filled would appear at the bottom of this list (sort by “Invoice Date” descending), and people will see and and put in the proper date.

Today the entity wasn’t appearing, though I saw in the database that the entity existed. When I manually went into the entity and filled in the Invoice Date, then it appeared in the correct view. When I removed the date, the entity disappeared.

It would be good for entities with undefined values to still appear. We’ve relied on this behavior for our workflow, and there’s currently no way for people to check on this without an architect manually checking the database and comparing it with the view. This is very disruptive for us.

Why not just update the filter to include entities where the date field is empty?

I think for most people, if I have a filter that should only show me entities in the last 2 months, I wouldn’t want to see entities which have no value.

Because… :man_facepalming:

I totally overlooked this option. Thank you for covering my embarrassing mistake. :sweat_smile:

1 Like