Your software
My Mautic version is: 4.4.9
My PHP version is: 8.0.30
My Database type and version is: MySQL 8.0.23
Your problem
My problem is:
I’m having an issue when trying to apply a filter within segments.
I want to view all users who have a null birthdate in the database, but when I use “empty,” it doesn’t return any contacts, even though I know there are many null entries in the database. Is there another way to filter this data to retrieve null values?
Please note that it’s a ‘datetime’ field.
These errors are showing in the log:
There’s no error log; it simply doesn’t fetch any results.
Steps I have tried to fix the problem:
I attempted to filter using ‘is empty,’ but it doesn’t provide me with any results.