EntityQuery with or statement

[raidri]

Hi,

i need the following SQL Statement with seam.

SELECT * from table WHERE (state = 'A' or state = 'b') and value = 'hello';

This restriction don't work. cause the or statement is not possible.

private static final String[] RESTRICTIONS = {

  "(lending.state = #{lendingList.lendingState} or lending.displayState = #{lendingList.lendingState})",

  "lower(lending.event) like concat('%',lower(#{lendingList.event}),'%')",

  "lower(lending.username) in (#{lendingList.racfUsernames})",

  "lower(lending.costCenter) like concat(lower(#{lendingList.costCenter}),'%')",

  "lendingProduct.product.lendingGroup IN (#{lendingList.lendingGroup})",

  "lendingProduct.product.name like concat('%',lower(#{lendingList.productName}),'%')",

  "lendingItem.item.identifier like concat('%', lower(#{lendingList.itemIdentifier}),'%')",

  "lendingProduct.product.productGroup.id = #{lendingList.productGroupId}"};

What i 've to change to make the statement valid ?

Thanks a lot.

raidri

[subaochen]

hi,

just coding like this:

private List<String> statusList;

...

"lending.state in (#{not empty lendingList.statusList ? lendingList.statusList : null)",

Hope to help you.

[raidri]

i think that can't help me, cause i've two different fields first "state" and second "displayState". if one of this states has the selected #{lendingList.lendingState} the lendingItem should be visible