Hi,
I was wonder if a null value affects the result of the collection datasource result.
select e from cps$Transaction e
where e.account.id = :ds$accountDs
or e.receiver.id = :ds$accountDsccountDs
When I run any of the conditions separately I receive expected results, however when I run the full query I receive an unexpected result. The only thing is that receiver is mainly null unless transaction type is transfer not sure if that could be the cause if so how would I resolve this.
Thanks