Is Empty filter not working.

[smartinsar]

Hi, can you help me please.

I have entity Costs with foreign field named CostFilters.

When I try to use filter Is empty it show me No data.
If I Re-save any Costs without any changes that has empty field CostFilters, then the only this Costs will show like Is Empty.


Also Is not empty looks like not working, cause it shows all Costs with/without CostFilters field.

How can I solve this issue?
Thank you.

[item]

Hi,
if you have last 8.1.1 it must be resolved.
(i have see this kind of issue was resolved in 8.1.x if not forget).. see github issue closed.

[smartinsar]

The latest version didn't resolve my issue.

[victor]

Hi smartinsar,

Can't reproduce your problem. Tested Is Empty for different fields - filtering is successful everywhere (for EspoCRM 8.1.1).

- Did you make any modifications to the EspoCRM files?
- How does the Is Empty filter work for other fields and for other entities?
- What type of field is your screenshot referring to?

[yuri]

Please provide more details about the relationship between Cost and CostFilter entity types. Is it one-to-many or many-to-many?


> If I Re-save any Costs without any changes that has empty field CostFilters, then the only this Costs will show like Is Empty.

I don't understand this. Could you explain more detail?