details: /erp/devel/pi/rev/79d70b18309e
changeset: 9116:79d70b18309e
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Tue Dec 14 10:43:05 2010 +0100
summary: fixed bug 15032: On the dataset definition it is possible to add a
table defined from a view
diffstat:
src-db/database/sourcedata/AD_VAL_RULE.xml | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diffs (15 lines):
diff -r e6d5130ae738 -r 79d70b18309e src-db/database/sourcedata/AD_VAL_RULE.xml
--- a/src-db/database/sourcedata/AD_VAL_RULE.xml Tue Dec 14 10:35:53
2010 +0100
+++ b/src-db/database/sourcedata/AD_VAL_RULE.xml Tue Dec 14 10:43:05
2010 +0100
@@ -1497,8 +1497,10 @@
<!--8286A51A2C2C494798EABA6D27CA534D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--8286A51A2C2C494798EABA6D27CA534D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--8286A51A2C2C494798EABA6D27CA534D--> <NAME><![CDATA[AD_DataSet_Table
access level]]></NAME>
+<!--8286A51A2C2C494798EABA6D27CA534D--> <DESCRIPTION><![CDATA[Filters tables
removing views and taking into account access level]]></DESCRIPTION>
<!--8286A51A2C2C494798EABA6D27CA534D--> <TYPE><![CDATA[S]]></TYPE>
-<!--8286A51A2C2C494798EABA6D27CA534D--> <CODE><![CDATA[((ad_table.accesslevel
in ('3','1','7') and exists(select 1 from ad_dataset
+<!--8286A51A2C2C494798EABA6D27CA534D--> <CODE><![CDATA[ad_table.isView='N'
+and ((ad_table.accesslevel in ('3','1','7') and exists(select 1 from ad_dataset
where ad_dataset_id =
@AD_DATASET_ID@
and ad_dataset.accesslevel = '1'))
OR
(ad_table.accesslevel in ('4','6','7') and exists(select 1 from
ad_dataset
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
