details:   /erp/devel/pi/rev/87c027fb8bd2
changeset: 9453:87c027fb8bd2
user:      Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date:      Wed Dec 29 18:08:55 2010 +0100
summary:   [OBCQL] Changed links on example query list widgets.

diffstat:

 
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
 |  48 +++------
 
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
 |   8 +-
 2 files changed, 20 insertions(+), 36 deletions(-)

diffs (214 lines):

diff -r e82cba7d05b9 -r 87c027fb8bd2 
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
--- 
a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
  Wed Dec 29 17:59:25 2010 +0100
+++ 
b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
  Wed Dec 29 18:08:55 2010 +0100
@@ -9,12 +9,10 @@
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  
<DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <NAME><![CDATA[Date]]></NAME>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--15817E30D88A4E04ACA56D1E92D24FD7-->  
<LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  
<AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--15817E30D88A4E04ACA56D1E92D24FD7-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--15817E30D88A4E04ACA56D1E92D24FD7-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--15817E30D88A4E04ACA56D1E92D24FD7-->  
<AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
+<!--15817E30D88A4E04ACA56D1E92D24FD7-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--15817E30D88A4E04ACA56D1E92D24FD7--></OBCQL_QUERY_COLUMN>
 
 <!--1FCFFA0840074019BF84BBD9E507CB91--><OBCQL_QUERY_COLUMN>
@@ -26,12 +24,10 @@
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  
<DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <NAME><![CDATA[Date]]></NAME>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--1FCFFA0840074019BF84BBD9E507CB91-->  
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  
<AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--1FCFFA0840074019BF84BBD9E507CB91-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--1FCFFA0840074019BF84BBD9E507CB91-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--1FCFFA0840074019BF84BBD9E507CB91-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
+<!--1FCFFA0840074019BF84BBD9E507CB91-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--1FCFFA0840074019BF84BBD9E507CB91--></OBCQL_QUERY_COLUMN>
 
 <!--379830F53AF44639B79DB5AB113A575F--><OBCQL_QUERY_COLUMN>
@@ -60,12 +56,12 @@
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  
<DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <NAME><![CDATA[Business 
Partner]]></NAME>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
+<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  
<LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
+<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--3C3DBC6021C94CFFA82AF855A7AF6C2F--></OBCQL_QUERY_COLUMN>
 
 <!--4FE8DE4D7CF94B128CBA09973BD21C1D--><OBCQL_QUERY_COLUMN>
@@ -112,12 +108,10 @@
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <NAME><![CDATA[Amount]]></NAME>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  
<SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--56DC401F52BF4BE593C782240AE4AB67-->  
<LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--56DC401F52BF4BE593C782240AE4AB67-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--56DC401F52BF4BE593C782240AE4AB67-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--56DC401F52BF4BE593C782240AE4AB67-->  
<AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID>
+<!--56DC401F52BF4BE593C782240AE4AB67-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--56DC401F52BF4BE593C782240AE4AB67--></OBCQL_QUERY_COLUMN>
 
 <!--6B151041105E4DD0805AC2F709A7A81E--><OBCQL_QUERY_COLUMN>
@@ -129,12 +123,10 @@
 <!--6B151041105E4DD0805AC2F709A7A81E-->  
<DISPLAY_EXPRESSION><![CDATA[paymentDate]]></DISPLAY_EXPRESSION>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <NAME><![CDATA[Date]]></NAME>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--6B151041105E4DD0805AC2F709A7A81E-->  
<LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  
<AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--6B151041105E4DD0805AC2F709A7A81E-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--6B151041105E4DD0805AC2F709A7A81E-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--6B151041105E4DD0805AC2F709A7A81E-->  
<AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID>
+<!--6B151041105E4DD0805AC2F709A7A81E-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--6B151041105E4DD0805AC2F709A7A81E--></OBCQL_QUERY_COLUMN>
 
 <!--70CEB497CA254F3C892AE0B68920897D--><OBCQL_QUERY_COLUMN>
@@ -146,12 +138,12 @@
 <!--70CEB497CA254F3C892AE0B68920897D-->  
<DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <NAME><![CDATA[Business 
Partner]]></NAME>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--70CEB497CA254F3C892AE0B68920897D-->  
<LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
+<!--70CEB497CA254F3C892AE0B68920897D-->  
<LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--70CEB497CA254F3C892AE0B68920897D-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--70CEB497CA254F3C892AE0B68920897D-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--70CEB497CA254F3C892AE0B68920897D-->  
<AD_TAB_ID><![CDATA[C4B6506838E14A349D6717D6856F1B56]]></AD_TAB_ID>
+<!--70CEB497CA254F3C892AE0B68920897D-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--70CEB497CA254F3C892AE0B68920897D--></OBCQL_QUERY_COLUMN>
 
 <!--742D993ADF7444318F8CAF38DDCB1997--><OBCQL_QUERY_COLUMN>
@@ -163,12 +155,12 @@
 <!--742D993ADF7444318F8CAF38DDCB1997-->  
<DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <NAME><![CDATA[Business 
Partner]]></NAME>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--742D993ADF7444318F8CAF38DDCB1997-->  
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
+<!--742D993ADF7444318F8CAF38DDCB1997-->  
<LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--742D993ADF7444318F8CAF38DDCB1997-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
+<!--742D993ADF7444318F8CAF38DDCB1997-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--742D993ADF7444318F8CAF38DDCB1997--></OBCQL_QUERY_COLUMN>
 
 <!--94B1051270614629B02531C5F894BCF1--><OBCQL_QUERY_COLUMN>
@@ -180,12 +172,12 @@
 <!--94B1051270614629B02531C5F894BCF1-->  
<DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
 <!--94B1051270614629B02531C5F894BCF1-->  <NAME><![CDATA[Business 
Partner]]></NAME>
 <!--94B1051270614629B02531C5F894BCF1-->  <WIDTH><![CDATA[40]]></WIDTH>
-<!--94B1051270614629B02531C5F894BCF1-->  
<LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
+<!--94B1051270614629B02531C5F894BCF1-->  
<LINK_EXPRESSION><![CDATA[businessPartnerId]]></LINK_EXPRESSION>
 <!--94B1051270614629B02531C5F894BCF1-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--94B1051270614629B02531C5F894BCF1-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
 <!--94B1051270614629B02531C5F894BCF1-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
 <!--94B1051270614629B02531C5F894BCF1-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--94B1051270614629B02531C5F894BCF1-->  
<AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
+<!--94B1051270614629B02531C5F894BCF1-->  <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
 <!--94B1051270614629B02531C5F894BCF1--></OBCQL_QUERY_COLUMN>
 
 <!--9FC7E75A21F34920AA2695261935FD06--><OBCQL_QUERY_COLUMN>
@@ -214,12 +206,10 @@
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  
<DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <NAME><![CDATA[Date]]></NAME>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  
<AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
+<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--BBBF2F44391C43F98B4FDEAF62BE81D1--></OBCQL_QUERY_COLUMN>
 
 <!--CDC05CE5642E4327BA12FEA50597A8A3--><OBCQL_QUERY_COLUMN>
@@ -232,12 +222,10 @@
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <NAME><![CDATA[Amount]]></NAME>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  
<SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--CDC05CE5642E4327BA12FEA50597A8A3-->  
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--CDC05CE5642E4327BA12FEA50597A8A3-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <AD_TAB_ID><![CDATA[263]]></AD_TAB_ID>
+<!--CDC05CE5642E4327BA12FEA50597A8A3-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--CDC05CE5642E4327BA12FEA50597A8A3--></OBCQL_QUERY_COLUMN>
 
 <!--FAB0DB1A67D948DB85AD5918B7845ABF--><OBCQL_QUERY_COLUMN>
@@ -250,12 +238,10 @@
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <NAME><![CDATA[Amount]]></NAME>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  
<SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <AD_TAB_ID><![CDATA[290]]></AD_TAB_ID>
+<!--FAB0DB1A67D948DB85AD5918B7845ABF-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--FAB0DB1A67D948DB85AD5918B7845ABF--></OBCQL_QUERY_COLUMN>
 
 <!--FE9812790C0943C584999CEAAD93E95D--><OBCQL_QUERY_COLUMN>
@@ -268,12 +254,10 @@
 <!--FE9812790C0943C584999CEAAD93E95D-->  <NAME><![CDATA[Amount]]></NAME>
 <!--FE9812790C0943C584999CEAAD93E95D-->  
<SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <WIDTH><![CDATA[20]]></WIDTH>
-<!--FE9812790C0943C584999CEAAD93E95D-->  
<LINK_EXPRESSION><![CDATA[finpaymentId]]></LINK_EXPRESSION>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--FE9812790C0943C584999CEAAD93E95D-->  
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--FE9812790C0943C584999CEAAD93E95D-->  <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
-<!--FE9812790C0943C584999CEAAD93E95D-->  <HAS_LINK><![CDATA[Y]]></HAS_LINK>
-<!--FE9812790C0943C584999CEAAD93E95D-->  
<AD_TAB_ID><![CDATA[F7A52FDAAA0346EFA07D53C125B40404]]></AD_TAB_ID>
+<!--FE9812790C0943C584999CEAAD93E95D-->  <HAS_LINK><![CDATA[N]]></HAS_LINK>
 <!--FE9812790C0943C584999CEAAD93E95D--></OBCQL_QUERY_COLUMN>
 
 </data>
diff -r e82cba7d05b9 -r 87c027fb8bd2 
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
--- 
a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
  Wed Dec 29 17:59:25 2010 +0100
+++ 
b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
  Wed Dec 29 18:08:55 2010 +0100
@@ -7,7 +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.name as businessPartnerName,
+       inv.businessPartner.id as businessPartnerId, inv.businessPartner.name 
as businessPartnerName,
        inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount
 from Invoice as inv
 where inv.businessPartner.name like :businessPartnerName
@@ -26,7 +26,7 @@
 <!--58BCB96595FA45678CC1423402238309-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--58BCB96595FA45678CC1423402238309-->  
<OBKMO_WIDGET_CLASS_ID><![CDATA[34F279BBB85945519DC38F21573106C0]]></OBKMO_WIDGET_CLASS_ID>
 <!--58BCB96595FA45678CC1423402238309-->  <HQL><![CDATA[select inv.id as 
invoiceId, inv.documentNo as documentNo,
-       inv.businessPartner.name as businessPartnerName,
+       inv.businessPartner.id as businessPartnerId, inv.businessPartner.name 
as businessPartnerName,
        inv.invoiceDate as invoiceDate, inv.grandTotalAmount as grandTotalAmount
 from Invoice as inv
 where inv.businessPartner.name like :businessPartnerName
@@ -45,7 +45,7 @@
 <!--E5A0DC8536134185AC8B1897F15DB816-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--E5A0DC8536134185AC8B1897F15DB816-->  
<OBKMO_WIDGET_CLASS_ID><![CDATA[2662490B7D3B4F80AF308C88F6DB68C0]]></OBKMO_WIDGET_CLASS_ID>
 <!--E5A0DC8536134185AC8B1897F15DB816-->  <HQL><![CDATA[select p.id as 
finpaymentId, p.documentNo as documentNo,
-       p.businessPartner.name as businessPartnerName,
+       p.businessPartner.id as businessPartnerId, p.businessPartner.name as 
businessPartnerName,
        p.paymentDate as paymentDate, p.amount as amount
 from FIN_Payment as p
 where p.businessPartner.name like :businessPartnerName
@@ -64,7 +64,7 @@
 <!--F94AEB4680AD4AD48255071903000A43-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--F94AEB4680AD4AD48255071903000A43-->  
<OBKMO_WIDGET_CLASS_ID><![CDATA[F8E4F382BCFB441CADBB4AC693C41C93]]></OBKMO_WIDGET_CLASS_ID>
 <!--F94AEB4680AD4AD48255071903000A43-->  <HQL><![CDATA[select p.id as 
finpaymentId, p.documentNo as documentNo,
-       p.businessPartner.name as businessPartnerName,
+       p.businessPartner.id as businessPartnerId, p.businessPartner.name as 
businessPartnerName,
        p.paymentDate as paymentDate, p.amount as amount
 from FIN_Payment as p
 where p.businessPartner.name like :businessPartnerName

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to