[referecne] Fixed reference and subreferences selection in column
authorAsier Lostalé <asier.lostale@openbravo.com>
Mon, 30 Nov 2009 17:46:41 +0100
changeset 6121 77b30b0c9e9d
parent 6120 e8a7f530a395
child 6122 ff63b60362de
[referecne] Fixed reference and subreferences selection in column
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
src-db/database/sourcedata/AD_VAL_RULE.xml
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Nov 30 17:46:18 2009 +0100
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Nov 30 17:46:41 2009 +0100
@@ -46,8 +46,8 @@
 <!--4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--4-->  <NAME><![CDATA[AD_Reference Values]]></NAME>
-<!--4-->  <DESCRIPTION><![CDATA[Reference (List and Table) selection]]></DESCRIPTION>
+<!--4-->  <NAME><![CDATA[AD_Reference Subreferences]]></NAME>
+<!--4-->  <DESCRIPTION><![CDATA[Subreference]]></DESCRIPTION>
 <!--4-->  <HELP><![CDATA[(not DataType and Independent)]]></HELP>
 <!--4-->  <VALIDATIONTYPE><![CDATA[T]]></VALIDATIONTYPE>
 <!--4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml	Mon Nov 30 17:46:18 2009 +0100
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml	Mon Nov 30 17:46:41 2009 +0100
@@ -34,8 +34,8 @@
 <!--4-->  <AD_KEY><![CDATA[129]]></AD_KEY>
 <!--4-->  <AD_DISPLAY><![CDATA[130]]></AD_DISPLAY>
 <!--4-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
-<!--4-->  <WHERECLAUSE><![CDATA[AD_Reference.ValidationType in ('T','L','S')]]></WHERECLAUSE>
-<!--4-->  <ORDERBYCLAUSE><![CDATA[AD_Reference.ValidationType, 2]]></ORDERBYCLAUSE>
+<!--4-->  <WHERECLAUSE><![CDATA[AD_Reference.IsBaseReference = 'N']]></WHERECLAUSE>
+<!--4-->  <ORDERBYCLAUSE><![CDATA[AD_Reference.ParentReference_ID, 2]]></ORDERBYCLAUSE>
 <!--4--></AD_REF_TABLE>
 
 <!--100--><AD_REF_TABLE>
--- a/src-db/database/sourcedata/AD_VAL_RULE.xml	Mon Nov 30 17:46:18 2009 +0100
+++ b/src-db/database/sourcedata/AD_VAL_RULE.xml	Mon Nov 30 17:46:41 2009 +0100
@@ -77,10 +77,10 @@
 <!--115-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--115-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--115-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--115-->  <NAME><![CDATA[AD_Reference List or Table]]></NAME>
-<!--115-->  <DESCRIPTION><![CDATA[List or Table validation choices]]></DESCRIPTION>
+<!--115-->  <NAME><![CDATA[AD_Reference Subreference]]></NAME>
+<!--115-->  <DESCRIPTION><![CDATA[Subreference validation choices]]></DESCRIPTION>
 <!--115-->  <TYPE><![CDATA[S]]></TYPE>
-<!--115-->  <CODE><![CDATA[AD_Reference.ValidationType=(CASE @AD_Reference_ID@ WHEN '17' THEN 'L' WHEN '25' THEN 'L' WHEN '30' THEN 'S' WHEN '28' THEN 'L' ELSE 'T' END)]]></CODE>
+<!--115-->  <CODE><![CDATA[AD_Reference.ParentReference_ID=@AD_Reference_ID@]]></CODE>
 <!--115-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--115--></AD_VAL_RULE>