Secondary whereclause field will only be visible in tables belonging to the dataset AD
authorAntonio Moreno <antonio.moreno@openbravo.com>
Fri, 14 May 2010 15:33:15 +0200
changeset 7326 1b6ae3b43361
parent 7325 57215ecab784
child 7327 a68108a26adc
Secondary whereclause field will only be visible in tables belonging to the dataset AD
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri May 14 13:48:21 2010 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Fri May 14 15:33:15 2010 +0200
@@ -257183,7 +257183,8 @@
 <!--31A70D5921994990B17329ECB16314A0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--31A70D5921994990B17329ECB16314A0-->  <NAME><![CDATA[Secondarywhereclause]]></NAME>
 <!--31A70D5921994990B17329ECB16314A0-->  <DESCRIPTION><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.]]></DESCRIPTION>
-<!--31A70D5921994990B17329ECB16314A0-->  <HELP><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.]]></HELP>
+<!--31A70D5921994990B17329ECB16314A0-->  <HELP><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table. This secondary whereclause needs to be written in SQL, and only applies for the dataset AD. When export.database is executed, this whereclause will be applied for the data inside the table, and only the records complying with it will be exported. The rest of the records (the ones which do not comply with the whereclause) will be ignored both in export.database and update.database.
+The main purpose of this whereclause is to select which of the records in a particular table are part of sourcedata, and which ones are part of client data.]]></HELP>
 <!--31A70D5921994990B17329ECB16314A0-->  <COLUMNNAME><![CDATA[Secondarywhereclause]]></COLUMNNAME>
 <!--31A70D5921994990B17329ECB16314A0-->  <AD_TABLE_ID><![CDATA[4D8B61CFF8F04F38B2C9BF2E30D92024]]></AD_TABLE_ID>
 <!--31A70D5921994990B17329ECB16314A0-->  <AD_REFERENCE_ID><![CDATA[14]]></AD_REFERENCE_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Fri May 14 13:48:21 2010 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Fri May 14 15:33:15 2010 +0200
@@ -26471,7 +26471,8 @@
 <!--BD2D5C4D0AED4962B1EDF25726015579-->  <NAME><![CDATA[Secondary SQL Where Clause]]></NAME>
 <!--BD2D5C4D0AED4962B1EDF25726015579-->  <PRINTNAME><![CDATA[Secondary SQL Where Clause]]></PRINTNAME>
 <!--BD2D5C4D0AED4962B1EDF25726015579-->  <DESCRIPTION><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.]]></DESCRIPTION>
-<!--BD2D5C4D0AED4962B1EDF25726015579-->  <HELP><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.]]></HELP>
+<!--BD2D5C4D0AED4962B1EDF25726015579-->  <HELP><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table. This secondary whereclause needs to be written in SQL, and only applies for the dataset AD. When export.database is executed, this whereclause will be applied for the data inside the table, and only the records complying with it will be exported. The rest of the records (the ones which do not comply with the whereclause) will be ignored both in export.database and update.database.
+The main purpose of this whereclause is to select which of the records in a particular table are part of sourcedata, and which ones are part of client data.]]></HELP>
 <!--BD2D5C4D0AED4962B1EDF25726015579-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--BD2D5C4D0AED4962B1EDF25726015579--></AD_ELEMENT>
 
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri May 14 13:48:21 2010 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri May 14 15:33:15 2010 +0200
@@ -200914,11 +200914,13 @@
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <NAME><![CDATA[Secondary SQL Where Clause]]></NAME>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <DESCRIPTION><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.]]></DESCRIPTION>
-<!--DFD1092EB57A422082DA7585E6C7FE03-->  <HELP><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.]]></HELP>
+<!--DFD1092EB57A422082DA7585E6C7FE03-->  <HELP><![CDATA[This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table. This secondary whereclause needs to be written in SQL, and only applies for the dataset AD. When export.database is executed, this whereclause will be applied for the data inside the table, and only the records complying with it will be exported. The rest of the records (the ones which do not comply with the whereclause) will be ignored both in export.database and update.database.
+The main purpose of this whereclause is to select which of the records in a particular table are part of sourcedata, and which ones are part of client data.]]></HELP>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <AD_TAB_ID><![CDATA[1705E06D88D14A0DB0907E5B0A61D8D2]]></AD_TAB_ID>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <AD_COLUMN_ID><![CDATA[31A70D5921994990B17329ECB16314A0]]></AD_COLUMN_ID>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--DFD1092EB57A422082DA7585E6C7FE03-->  <DISPLAYLOGIC><![CDATA[@AD_Dataset_Id@='0']]></DISPLAYLOGIC>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--DFD1092EB57A422082DA7585E6C7FE03-->  <SEQNO><![CDATA[75]]></SEQNO>