details: /erp/devel/pi/rev/339a81060432
changeset: 12510:339a81060432
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri May 27 08:28:40 2011 +0200
summary: Fixes issue 17089: Enterprise Module Management window should only
show correct dataset
diffstat:
src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql | 8
++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diffs (32 lines):
diff -r 9d8f8f29867c -r 339a81060432
src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
--- a/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
Thu May 26 12:12:42 2011 +0200
+++ b/src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree_data.xsql
Fri May 27 08:28:40 2011 +0200
@@ -86,7 +86,7 @@
AND M.ISACTIVE = 'Y'
AND 1=1
AND M.HASREFERENCEDATA = 'Y'
- AND AD_DATASET.ACCESSLEVEL IN ('3','6','1') AND EXPORTALLOWED = 'Y'
+ AND EXPORTALLOWED = 'Y'
AND NOT EXISTS (SELECT 1 FROM AD_CLIENTMODULE CM
WHERE CM.ad_module_id = M.ad_module_id
AND CM.AD_CLIENT_ID = ?
@@ -96,7 +96,9 @@
AND OM.AD_CLIENT_ID = ?
AND (AD_IsOrgIncluded(?, OM.AD_Org_ID,
OM.AD_Client_ID)<>-1
OR AD_IsOrgIncluded(OM.AD_Org_ID, ?,
OM.AD_Client_ID)<>-1)
- AND OM.VERSION = M.VERSION))A
+ AND OM.VERSION = M.VERSION)
+ AND (((? != '0') AND AD_DATASET.ACCESSLEVEL IN ('1', '3'))
+ OR ((? = '0') AND AD_DATASET.ACCESSLEVEL IN ('3', '6')))) A
ORDER BY A.SeqNo
]]>
</Sql>
@@ -105,6 +107,8 @@
<Parameter name="client"/>
<Parameter name="org"/>
<Parameter name="org"/>
+ <Parameter name="org"/>
+ <Parameter name="org"/>
</SqlMethod>
<SqlMethod name="selectSubTree" type="preparedStatement" return="multiple">
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
