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

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