details: https://code.openbravo.com/erp/devel/pi/rev/4dc628a238c0
changeset: 19850:4dc628a238c0
user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at>
openbravo.com>
date: Thu Feb 28 13:41:35 2013 +0530
summary: Fixes Issue 22757: In sales order report the dateordered field is
not truncated
diffstat:
src/org/openbravo/erpCommon/ad_reports/OrderEdition_data.xsql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (14 lines):
diff -r b97cd735def7 -r 4dc628a238c0
src/org/openbravo/erpCommon/ad_reports/OrderEdition_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/OrderEdition_data.xsql Mon Mar
04 13:54:04 2013 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/OrderEdition_data.xsql Thu Feb
28 13:41:35 2013 +0530
@@ -66,8 +66,8 @@
<Parameter name="cCurrencyConv"/>
<Parameter name="adUserOrg" type="replace" optional="true" after=" AND
C_ORDER.AD_ORG_ID IN (" text="'1'"/>
<Parameter name="adUserClient" type="replace" optional="true" after=" AND
C_ORDER.AD_CLIENT_ID IN (" text="'1'"/>
- <Parameter name="dateFrom" optional="true" after="1=1"><![CDATA[ AND
C_ORDER.DATEORDERED >= TO_DATE(?)]]></Parameter>
- <Parameter name="dateTo" optional="true" after="1=1"><![CDATA[ AND
C_ORDER.DATEORDERED <= TO_DATE(?)]]></Parameter>
+ <Parameter name="dateFrom" optional="true" after="1=1"><![CDATA[ AND
TRUNC(C_ORDER.DATEORDERED, 'DD') >= TO_DATE(?)]]></Parameter>
+ <Parameter name="dateTo" optional="true" after="1=1"><![CDATA[ AND
TRUNC(C_ORDER.DATEORDERED, 'DD') <= TO_DATE(?)]]></Parameter>
<Parameter name="mWarehouseId" optional="true" after="1=1"><![CDATA[ AND
C_ORDER.M_WAREHOUSE_ID = ?]]></Parameter>
<Parameter name="cProjectId" optional="true" after="1=1"><![CDATA[ AND
C_PROJECT.C_PROJECT_ID = ?]]></Parameter>
<Parameter name="cRegionId" optional="true" type="argument" after="AND
1=1"><![CDATA[ AND C_LOCATION.C_REGION_ID IN]]></Parameter>
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
