Does null value affect where clause result in collection datasource

[mohamed20884]

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

[mohamed20884]

Never mind not sure why but it suddenly started working on its own for some reason even though I didn’t change anything.

Thanks