Fixes Issue 8433: In Traceability report, both Incoming & outgoing details are displayed by default ,when the user selects outgoing option.
authorSathiyan Sivaprakasam <sathiyan.sivaprakasam@openbravo.com>
Fri, 19 Jun 2009 11:53:50 +0530
changeset 4038 da2e7a5269c6
parent 4037 a8543f046eed
child 4044 d7b7924ec0c6
Fixes Issue 8433: In Traceability report, both Incoming & outgoing details are displayed by default ,when the user selects outgoing option.
src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports_data.xsql	Thu Jun 18 18:39:52 2009 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports_data.xsql	Fri Jun 19 11:53:50 2009 +0530
@@ -87,7 +87,7 @@
      AND	T.M_ATTRIBUTESETINSTANCE_ID  = ?
      AND	T.M_PRODUCT_ID  = ?
      AND	T.M_LOCATOR_ID  = ?
-     AND	1  = 1
+     AND 1=1
     ORDER BY T.MOVEMENTDATE,
        T.CREATED 
      ]]></Sql>
@@ -102,8 +102,8 @@
      <Parameter name="mAttributesetinstanceId"/>
      <Parameter name="mProductId"/>
      <Parameter name="mLocatorId"/>
-     <Parameter name="plusQty" optional="true" type="none" after="AND 1=1"><![CDATA[ AND (T.MOVEMENTTYPE <> 'P+' OR  T.MOVEMENTQTY < 0) ]]></Parameter>
-     <Parameter name="minusQty" optional="true" type="none" after="AND 1=1"><![CDATA[ AND (T.MOVEMENTTYPE <> 'P+' OR  T.MOVEMENTQTY > 0) ]]></Parameter>
+     <Parameter name="plusQty" optional="true" type="none" after="1=1" ><![CDATA[ AND (T.MOVEMENTTYPE <> 'P+' AND  T.MOVEMENTQTY > 0)]]></Parameter>
+     <Parameter name="minusQty" optional="true" type="none" after="1=1" ><![CDATA[ AND (T.MOVEMENTTYPE <> 'P+' AND  T.MOVEMENTQTY < 0)]]></Parameter>
   </SqlMethod>
   <SqlMethod name="selectProductionOut" type="preparedStatement" return="multiple">
     <SqlMethodComment></SqlMethodComment>