0 Replies Latest reply: Apr 11, 2012 2:48 AM by vidusha madan RSS

Help with EJB QL set restrictions

vidusha madan Newbie

Hi

 

I have a query that fetches data from a table. For this quesy I set restrictions as follows :

private static String[] RESTRICTIONS = {

  "customerBean.customerId in (#{context.scopedCustomers})",

  }

 

If context.scopedCustomers here is null the query matches it with all the records in the table. As a result all the data is fetched and displayed.

 

How can I modify/control this behaviour so that only those records are fetched where customer id is null.

 

Any help would be appreciated.