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