Closed
Description
Node: **v14.18.1**
Arch: **x64**
Platform: **freebsd**
Docker: **false**
Database: **pg**
ProjectOnRootDB: **false**
RootDB: **pg**
PackageVersion: **0.92.0**
Steps To Reproduce
- Create two tables.
- Add the "Has Many" relation between two tables (Link To Another Record column)
- Add some records to both tables. At least two records in the child table - one related to parent and one with null in the foreign key column.
- Use API to get records from parent table which have empty relation.
It is not possible to filter records without relation using the parameter where=(child_id,is,null). There is always an empty response.
The same problem occurs when using "is null" filter in UI.
When where=(child_id,isnot,null) is passed as a parameter you get only records which have a relation with the child table - which is ok.
Expected Behavior
User should be able to filter out records from the parent table without relation.