Servoy 6.1 self relation null check

Classic Servoy
1

Hi,

In Servoy 6.1 the below search always results in an empty foundset.
Relation ‘fin_ledger_to_fin_ledger$child’ is a left outer join self relation between two different columns (fin_ledger_id → parent_id).
Column ‘fin_ledger_id’ is the pk of table ‘fin_ledger’

_fs_ledger.find()
_fs_ledger.fin_ledger_to_fin_ledger$child.fin_ledger_id = '^'
_fs_ledger.search()

In Servoy 5.2 it results in the right (not empty) foundset (with the same data of course).

Anyone any ideas ?

2

what is the query that is generated?

3

That’s a good one ! Did not think of that.
I’ll be back…

Regards,