From: Jorg J. <jj...@us...> - 2002-08-25 05:12:11
|
Update of /cvsroot/compiere/client/Src/org/compiere/grid/tree In directory usw-pr-cvs1:/tmp/cvs-serv11278/Src/org/compiere/grid/tree Modified Files: VTree.java Log Message: . Index: VTree.java =================================================================== RCS file: /cvsroot/compiere/client/Src/org/compiere/grid/tree/VTree.java,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** VTree.java 23 Aug 2002 04:03:22 -0000 1.8 --- VTree.java 25 Aug 2002 05:12:09 -0000 1.9 *************** *** 383,391 **** cmdNode.append(" AND m.IsActive='Y' " + "AND (m.IsSummary='Y' OR m.Action='B'" ! + " OR EXISTS (SELECT * FROM AD_Window_Access wa WHERE wa.AD_Window_ID=m.AD_Window_ID AND wa.AD_Role_ID=XRole)" ! + " OR EXISTS (SELECT * FROM AD_Process_Access wa WHERE wa.AD_Process_ID=m.AD_Process_ID AND wa.AD_Role_ID=XRole)" ! + " OR EXISTS (SELECT * FROM AD_Form_Access wa WHERE wa.AD_Form_ID=m.AD_Form_ID AND wa.AD_Role_ID=XRole)" ! + " OR EXISTS (SELECT * FROM AD_Task_Access wa WHERE wa.AD_Task_ID=m.AD_Task_ID AND wa.AD_Role_ID=XRole)" ! + " OR EXISTS (SELECT * FROM AD_Workflow_Access wa WHERE wa.AD_Workflow_ID=m.AD_Workflow_ID AND wa.AD_Role_ID=XRole)" + ")"); } --- 383,391 ---- cmdNode.append(" AND m.IsActive='Y' " + "AND (m.IsSummary='Y' OR m.Action='B'" ! + " OR EXISTS (SELECT * FROM AD_Window_Access wa WHERE wa.AD_Window_ID=m.AD_Window_ID AND wa.AD_Role_ID=XRole AND wa.IsActive='Y')" ! + " OR EXISTS (SELECT * FROM AD_Process_Access wa WHERE wa.AD_Process_ID=m.AD_Process_ID AND wa.AD_Role_ID=XRole AND wa.IsActive='Y')" ! + " OR EXISTS (SELECT * FROM AD_Form_Access wa WHERE wa.AD_Form_ID=m.AD_Form_ID AND wa.AD_Role_ID=XRole AND wa.IsActive='Y')" ! + " OR EXISTS (SELECT * FROM AD_Task_Access wa WHERE wa.AD_Task_ID=m.AD_Task_ID AND wa.AD_Role_ID=XRole AND wa.IsActive='Y')" ! + " OR EXISTS (SELECT * FROM AD_Workflow_Access wa WHERE wa.AD_Workflow_ID=m.AD_Workflow_ID AND wa.AD_Role_ID=XRole AND wa.IsActive='Y')" + ")"); } |