I have created a relation
table1.field1 = table2.field1
table1.field2 = table2.field2
table1.field3 ^||= table2.field3
table1.field4 ^||= table2.field4
if for example table1.field4 and table2.field4 are both null then the relation doesn't find any data.
However, with the same data
if ( table1.find()) {
table1.field1 = table2.field1
table1.field2 = table2.field2
table1.field3 = '^||=' + table2.field3
table1.field4 = ' ^||=' + table2.field4
returns the expected data.
Can anyone help with why the relation doesn't return any data.
TIA