Datasource Query

Support
#1

Hi,

I have a query into a collectionDatasource linked to a Table that doesn’t work (Table is empty).

<collectionDatasource id="transactionsDs"
                              view="transaction">
            <query>
                <![CDATA[select DISTINCT e from crm$Transaction e
where   e.reseller = :ds$organizationDs OR e.buyer = :ds$organizationDs]]>
            </query>
        </collectionDatasource>

It’s strange because if I run separately:

<![CDATA[select DISTINCT e from crm$Transaction e
where   e.reseller = :ds$organizationDs 
  </query>

or

 <query>
                <![CDATA[select DISTINCT e from crm$Transaction e
where e.buyer = :ds$organizationDs]]>
  </query>

it works (Table is populated)!
Please advise!

#2

Solved!

I have null in database and I have to treat it separately (with is null).