0005521: 'Invoice Consignment Report' filter window fails in PostgreSQL

Description

Due to UUID changes, filter window of 'Invoice Consignment Report' does not work.

Steps To Reproduce

1) Using PostgreSQL, go to 'Warehouse Management || Analysis Tools || Invoice Consignment Report'.

14:54:44 [http-8384-Processor24] ERROR org.openbravo.erpCommon.utility.ComboTableData - Error of SQL in query: SELECT td0.M_Warehouse_ID AS ID, (COALESCE(TO_CHAR(TO_CHAR(td0.Name)),'')) AS NAME, '' AS DESCRIPTION
FROM M_Warehouse td0
WHERE td0.AD_Client_ID IN (1000000)
AND td0.AD_Org_ID IN ('0','1000000')
AND td0.AD_Client_ID=?
AND (td0.isActive = 'Y' OR td0.M_Warehouse_ID = (?) )
ORDER BY 2Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
14:54:44 [http-8384-Processor24] ERROR org.openbravo.erpCommon.ad_reports.ReportToInvoiceConsignmentJR - Error captured: javax.servlet.ServletException: 0

Proposed Solution

Patch attached for ad_reports/ReportToInvoiceConsignmentJR.java

Tags

UUID project

Attached Files

patch-invoice-to-consignment.diff [^] (1,229 bytes) 2008-10-14 16:09 [Show Content] [Hide Content]

### Eclipse Workspace Patch 1.0
#P openbravo
Index: src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java
===================================================================
--- src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java	(revision 8545)
+++ src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java	(working copy)
@@ -101,7 +99,7 @@
     xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
     xmlDocument.setParameter("mWarehouseId", strWarehouse);
     try {
-      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "M_Warehouse_ID", "M_Warehouse of Client", "", Utility.getContext(this, vars, "#User_Client",""), Utility.getContext(this, vars, "#AD_Client_ID", ""), 0);
+      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "M_Warehouse_ID", "M_Warehouse of Client", "", Utility.getContext(this, vars, "#User_Org",""), Utility.getContext(this, vars, "#User_Client", ""), 0);
       Utility.fillSQLParameters(this, vars, null, comboTableData,"", "");
       xmlDocument.setData("reportM_WAREHOUSEID","liststructure", comboTableData.select(false));
       comboTableData = null;

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0009564) svnbot (viewer) 2008-10-14 16:13	Repository: openbravo Revision: 8717 Author: rafaroda Date: 2008-10-14 16:13:47 +0200 (Tue, 14 Oct 2008) Fixes bug 0005521 Now 'Invoice Consignment Report' filter window works in PostgreSQL. --- U trunk/src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java --- https://dev.openbravo.com/websvn/openbravo/?rev=8717&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-10-14 16:09	rafaroda	New Issue
2008-10-14 16:09	rafaroda	Assigned To	=> rafaroda
2008-10-14 16:09	rafaroda	sf_bug_id	0 => 2166221
2008-10-14 16:09	rafaroda	File Added: patch-invoice-to-consignment.diff
2008-10-14 16:09	rafaroda	OBNetwork customer	=> No
2008-10-14 16:09	rafaroda	Regression testing	=> No
2008-10-14 16:12	rafaroda	Tag Attached: UUID project
2008-10-14 16:13	svnbot	Checkin
2008-10-14 16:13	svnbot	Note Added: 0009564
2008-10-14 16:13	svnbot	Status	new => resolved
2008-10-14 16:13	svnbot	Resolution	open => fixed
2008-10-14 16:13	svnbot	svn_revision	=> 8717
2008-12-16 11:14	psarobe	Status	resolved => closed