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

--------------------------------------------------------------
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.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/729254#729254]

Start a new discussion in EJB3 at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029]

_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to