[jboss-user] [EJB3] - Help with EJB QL set restrictions

vidusha madan do-not-reply at jboss.com
Wed Apr 11 02:48:56 EDT 2012

vidusha madan [https://community.jboss.org/people/vidusha] created the discussion

"Help with EJB QL set restrictions"

To view the discussion, visit: https://community.jboss.org/message/729254#729254


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.

Reply to this message by going to Community

Start a new discussion in EJB3 at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120411/99a364d5/attachment.html 

More information about the jboss-user mailing list