Just wondering if someone can provide guidance on where I can find useful information on how to model a more complex queries in OFBiz from java method i.e.
SELECT b.* FROM SECURITY_GROUP_PERMISSION a, SECURITY_PERMISSION b where a.PERMISSION_ID = b.PERMISSION_ID and a.GROUP_ID = 'BIZADMIN' or select a.* from SECURITY_PERMISSION a where a.PERMISSION_ID not in (select b.PERMISSION_ID from SECURITY_PERMISSION b, SECURITY_GROUP_PERMISSION c where b.PERMISSION_ID = c.PERMISSION_ID and c.GROUP_ID = 'FULLADMIN') Thanks in advanced. Mathius __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
