details: https://code.openbravo.com/erp/devel/pi/rev/2de3e09aac30
changeset: 21414:2de3e09aac30
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Tue Nov 05 14:06:17 2013 +0100
summary: Fixes issue 24997: Stock report does not filter by X-Y-Z values
properly
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql | 6
+++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (16 lines):
diff -r 4a0752df153f -r 2de3e09aac30
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql
Tue Nov 05 11:29:02 2013 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartner_data.xsql
Tue Nov 05 14:06:17 2013 +0100
@@ -55,9 +55,9 @@
<Parameter name="parDate" optional="true" after="AND 1=1"><![CDATA[ AND
M_TRANSACTION.MOVEMENTDATE < to_date(?)]]></Parameter>
<Parameter name="mProduct" optional="true" type="argument" after="AND
1=1"><![CDATA[ AND M_TRANSACTION.M_PRODUCT_ID IN]]></Parameter>
<Parameter name="mProductCategory" optional="true" after="AND
1=1"><![CDATA[ AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = ?]]></Parameter>
- <Parameter name="locatorX" optional="true" after="AND 1=1"><![CDATA[ AND
UPPER(M_LOCATOR.X) LIKE '%'||UPPER(?)||'%']]></Parameter>
- <Parameter name="locatorY" optional="true" after="AND 1=1"><![CDATA[ AND
UPPER(M_LOCATOR.Y) LIKE '%'||UPPER(?)||'%']]></Parameter>
- <Parameter name="locatorZ" optional="true" after="AND 1=1"><![CDATA[ AND
UPPER(M_LOCATOR.Z) LIKE '%'||UPPER(?)||'%']]></Parameter>
+ <Parameter name="locatorX" optional="true" after="AND 1=1"><![CDATA[ AND
UPPER(M_LOCATOR.X) = UPPER(?)]]></Parameter>
+ <Parameter name="locatorY" optional="true" after="AND 1=1"><![CDATA[ AND
UPPER(M_LOCATOR.Y) = UPPER(?)]]></Parameter>
+ <Parameter name="locatorZ" optional="true" after="AND 1=1"><![CDATA[ AND
UPPER(M_LOCATOR.Z) = UPPER(?)]]></Parameter>
</SqlMethod>
<SqlMethod name="set" type="constant" return="multiple">
<SqlMethodComment></SqlMethodComment>
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
