The SQL is selected null instead of an empty string when filtering to an empty value If the filtered field is a reference to another table and the filtered value is an empty string, regardless of whether the reference table supports inheritance or not, the records with the blank value of this field should be displayed. Currently, if the filter value is an empty string, it works only for the tables with inheritance, but most tables do not support inheritance.

Steps to reproduce

1. Go to Project management and accounting>Projects>All projects

2. Filter for ”is exactly”: "" in Integration source field

3. Apply the filter – the list is empty

Expected result

If the filtered field is a reference to another table and the filtered value is an empty string, regardless of whether the reference table supports inheritance or not, the records with the blank value of this field should be displayed.