Fixes issue 22740: Fixed broken db consistency test
authorAugusto Mauch <augusto.mauch@openbravo.com>
Tue, 08 Jan 2013 17:31:52 +0100
changeset 19172 b6cf1812e397
parent 19171 1e2fa048fc32
child 19173 be593a18eebe
Fixes issue 22740: Fixed broken db consistency test
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_FIELD.xml
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 15:25:28 2013 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 17:31:52 2013 +0100
@@ -9,6 +9,7 @@
 <!--FF80808133186ADD01331B3B733B0011-->  <HQL><![CDATA[select ad_message_get2(m.searchKey, :language) as regType, a.reconciledItems as itemNo, a.reconciledItemsAmount as itemAmt
 from APRM_Rec_Detail_v as a, ADMessage as m
 where a.type = m.searchKey and a.reconciliation.id = :reconciliationId]]></HQL>
+<!--FF80808133186ADD01331B3B733B0011-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--FF80808133186ADD01331B3B733B0011--></OBCQL_WIDGET_QUERY>
 
 </data>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_COLUMN.xml	Tue Jan 08 15:25:28 2013 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_COLUMN.xml	Tue Jan 08 17:31:52 2013 +0100
@@ -6,6 +6,8 @@
 <!--81001DA1F1D44C10979E937B1754307F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--81001DA1F1D44C10979E937B1754307F-->  <NAME><![CDATA[Type]]></NAME>
+<!--81001DA1F1D44C10979E937B1754307F-->  <DESCRIPTION><![CDATA[A distinct item characteristic used for processes and sometimes grouped within a category.]]></DESCRIPTION>
+<!--81001DA1F1D44C10979E937B1754307F-->  <HELP><![CDATA[The Type indicates the type of validation that will occur.  This can be SQL, Java Script or Java Language.]]></HELP>
 <!--81001DA1F1D44C10979E937B1754307F-->  <COLUMNNAME><![CDATA[Type]]></COLUMNNAME>
 <!--81001DA1F1D44C10979E937B1754307F-->  <AD_TABLE_ID><![CDATA[87AB97C7EED3429BBEFE9EF28EFACC08]]></AD_TABLE_ID>
 <!--81001DA1F1D44C10979E937B1754307F-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
@@ -21,6 +23,7 @@
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--81001DA1F1D44C10979E937B1754307F-->  <AD_ELEMENT_ID><![CDATA[600]]></AD_ELEMENT_ID>
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--81001DA1F1D44C10979E937B1754307F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -1606,7 +1609,9 @@
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A679FE2F67C0486CBFB774E72A76618B-->  <NAME><![CDATA[Obserds_Datasource_ID]]></NAME>
+<!--A679FE2F67C0486CBFB774E72A76618B-->  <NAME><![CDATA[Datasource]]></NAME>
+<!--A679FE2F67C0486CBFB774E72A76618B-->  <DESCRIPTION><![CDATA[The datasource ]]></DESCRIPTION>
+<!--A679FE2F67C0486CBFB774E72A76618B-->  <HELP><![CDATA[The datasource provides data from the database or from in-memory data.]]></HELP>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <COLUMNNAME><![CDATA[Obserds_Datasource_ID]]></COLUMNNAME>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <AD_TABLE_ID><![CDATA[87AB97C7EED3429BBEFE9EF28EFACC08]]></AD_TABLE_ID>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
@@ -1620,6 +1625,7 @@
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A679FE2F67C0486CBFB774E72A76618B-->  <AD_ELEMENT_ID><![CDATA[73C534367AFA4C28A9F8767D59AAE37E]]></AD_ELEMENT_ID>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--A679FE2F67C0486CBFB774E72A76618B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_FIELD.xml	Tue Jan 08 15:25:28 2013 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_FIELD.xml	Tue Jan 08 17:31:52 2013 +0100
@@ -6,6 +6,8 @@
 <!--82D5C58E310948088A4FE87611B1D84A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--82D5C58E310948088A4FE87611B1D84A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--82D5C58E310948088A4FE87611B1D84A-->  <NAME><![CDATA[Type]]></NAME>
+<!--82D5C58E310948088A4FE87611B1D84A-->  <DESCRIPTION><![CDATA[A distinct item characteristic used for processes and sometimes grouped within a category.]]></DESCRIPTION>
+<!--82D5C58E310948088A4FE87611B1D84A-->  <HELP><![CDATA[The Type indicates the type of validation that will occur.  This can be SQL, Java Script or Java Language.]]></HELP>
 <!--82D5C58E310948088A4FE87611B1D84A-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--82D5C58E310948088A4FE87611B1D84A-->  <AD_TAB_ID><![CDATA[8BA14DE095DE496A82A84FE53F0B9821]]></AD_TAB_ID>
 <!--82D5C58E310948088A4FE87611B1D84A-->  <AD_COLUMN_ID><![CDATA[81001DA1F1D44C10979E937B1754307F]]></AD_COLUMN_ID>
@@ -33,6 +35,8 @@
 <!--90A30A5448AB4813BECCD8804DFF8592-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--90A30A5448AB4813BECCD8804DFF8592-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--90A30A5448AB4813BECCD8804DFF8592-->  <NAME><![CDATA[Datasource]]></NAME>
+<!--90A30A5448AB4813BECCD8804DFF8592-->  <DESCRIPTION><![CDATA[The datasource ]]></DESCRIPTION>
+<!--90A30A5448AB4813BECCD8804DFF8592-->  <HELP><![CDATA[The datasource provides data from the database or from in-memory data.]]></HELP>
 <!--90A30A5448AB4813BECCD8804DFF8592-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--90A30A5448AB4813BECCD8804DFF8592-->  <AD_TAB_ID><![CDATA[8BA14DE095DE496A82A84FE53F0B9821]]></AD_TAB_ID>
 <!--90A30A5448AB4813BECCD8804DFF8592-->  <AD_COLUMN_ID><![CDATA[A679FE2F67C0486CBFB774E72A76618B]]></AD_COLUMN_ID>
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 15:25:28 2013 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 17:31:52 2013 +0100
@@ -7,6 +7,7 @@
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <OBKMO_WIDGET_CLASS_ID><![CDATA[147D825456D54D0486C3D7072531C5C9]]></OBKMO_WIDGET_CLASS_ID>
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <HQL><![CDATA[select inv.id as invoiceId, inv.documentNo as documentNo,        inv.businessPartner.id as businessPartnerId, inv.businessPartner.name as businessPartnerName,        inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount,        inv.currency.iSOCode as currency, inv.paymentTerms.name as paymentTerms,        inv.outstandingAmount as outstandingAmount, inv.daysTillDue as daysTillDue,        inv.dueAmount as dueAmount, inv.organization.name as organizationName from Invoice as inv where inv.businessPartner.name like :businessPartnerName       and inv.documentNo like :documentNo       and inv.processed = true       and inv.paymentComplete = false       and inv.salesTransaction = true       and inv.client.id = :client       and inv.organization.id in (:organizationList)       and inv.organization.name like :organizationName       and @optional_filters@ order by inv.invoiceDate]]></HQL>
+<!--1EF87E8E961A4E5BA3B41E1AB772B47C-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--1EF87E8E961A4E5BA3B41E1AB772B47C--></OBCQL_WIDGET_QUERY>
 
 <!--58BCB96595FA45678CC1423402238309--><OBCQL_WIDGET_QUERY>
@@ -32,6 +33,7 @@
       and inv.organization.name like :organizationName
       and @optional_filters@
 order by inv.invoiceDate]]></HQL>
+<!--58BCB96595FA45678CC1423402238309-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--58BCB96595FA45678CC1423402238309--></OBCQL_WIDGET_QUERY>
 
 <!--E5A0DC8536134185AC8B1897F15DB816--><OBCQL_WIDGET_QUERY>
@@ -55,6 +57,7 @@
       and p.organization.name like :organizationName
       and @optional_filters@
 order by p.paymentDate]]></HQL>
+<!--E5A0DC8536134185AC8B1897F15DB816-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--E5A0DC8536134185AC8B1897F15DB816--></OBCQL_WIDGET_QUERY>
 
 <!--F5DEE669DD8047FB831A12064BB277BE--><OBCQL_WIDGET_QUERY>
@@ -97,6 +100,7 @@
     and ol.salesOrder.organization.name like :organizationName 
     and @optional_filters@ 
   order by ol.salesOrder.scheduledDeliveryDate, ol.salesOrder.documentNo]]></HQL>
+<!--F5DEE669DD8047FB831A12064BB277BE-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--F5DEE669DD8047FB831A12064BB277BE--></OBCQL_WIDGET_QUERY>
 
 <!--F94AEB4680AD4AD48255071903000A43--><OBCQL_WIDGET_QUERY>
@@ -120,6 +124,7 @@
       and p.organization.name like :organizationName
       and @optional_filters@
 order by p.paymentDate]]></HQL>
+<!--F94AEB4680AD4AD48255071903000A43-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--F94AEB4680AD4AD48255071903000A43--></OBCQL_WIDGET_QUERY>
 
 </data>
--- a/modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 15:25:28 2013 +0100
+++ b/modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 17:31:52 2013 +0100
@@ -15,6 +15,7 @@
 and ol.product.name like :pname
 group by product.name, product.uOM.name, product.id, product.uOM.id 
 order by sum(orderedQuantity) desc]]></HQL>
+<!--CFDF8EE593F04CFE9709F5AD19A3A573-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--CFDF8EE593F04CFE9709F5AD19A3A573--></OBCQL_WIDGET_QUERY>
 
 <!--D2003CD3F9984BF39457BA1F2FFF01C9--><OBCQL_WIDGET_QUERY>
@@ -46,6 +47,7 @@
 	and tel.expenseSheet.businessPartner=u.businessPartner
 	and u.id=:user
 order by  tel.expenseSheet.reportDate, tel.expenseSheet.documentNo]]></HQL>
+<!--D2003CD3F9984BF39457BA1F2FFF01C9-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--D2003CD3F9984BF39457BA1F2FFF01C9--></OBCQL_WIDGET_QUERY>
 
 </data>
--- a/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 15:25:28 2013 +0100
+++ b/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Tue Jan 08 17:31:52 2013 +0100
@@ -18,6 +18,7 @@
   and q.organization.id IN (:organizationList)
   and @optional_filters@
 group by q.documentStatus]]></HQL>
+<!--11D052605994493E905FF9A45591D84D-->  <TYPE><![CDATA[HQL]]></TYPE>
 <!--11D052605994493E905FF9A45591D84D--></OBCQL_WIDGET_QUERY>
 
 </data>