Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024612Retail ModulesWeb POSpublic2013-08-28 12:432013-09-17 13:14
Reporterjecharri 
Assigned Toumartirena 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRMP27Fixed in VersionRMP27 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024612: Little problem in Price list query
DescriptionLittle problem in Price list query

If you have a price list version with column "valid from date" as date+time the query in file "modules/org.openbravo.retail.posterminal/src/org/openbravo/retail/posterminal/POSUtils.java" and line 236 is not going to work.


Steps To Reproduce-
Proposed Solution-change from
+ priceListId + "' and pplv.validFromDate <= '" + format.format(terminalDate)
to
+ priceListId + "' and to_char(pplv.validFromDate,'yyyy-mm-dd') <= '" + format.format(terminalDate)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-08-28 12:43jecharriNew Issue
2013-08-28 12:43jecharriAssigned To => marvintm
2013-08-28 12:43jecharriResolution time => 1379196000
2013-08-28 12:43jecharriTriggers an Emergency Pack => No
2013-09-03 18:49marvintmAssigned Tomarvintm => umartirena
2013-09-06 10:49hgbotCheckin
2013-09-06 10:49hgbotNote Added: 0060958
2013-09-06 10:49hgbotStatusnew => resolved
2013-09-06 10:49hgbotResolutionopen => fixed
2013-09-06 10:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3ae6c36f9975992cea6f61d82a0f783b17a87e9c [^]
2013-09-10 09:59hgbotCheckin
2013-09-10 09:59hgbotNote Added: 0061040
2013-09-10 09:59hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3ae6c36f9975992cea6f61d82a0f783b17a87e9c [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/3ae6c36f9975992cea6f61d82a0f783b17a87e9c [^]
2013-09-17 13:14marvintmReview Assigned To => marvintm
2013-09-17 13:14marvintmStatusresolved => closed
2013-09-17 13:14marvintmFixed in Version => RMP27

Notes
(0060958)
hgbot   
2013-09-06 10:49   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 3ae6c36f9975992cea6f61d82a0f783b17a87e9c
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Fri Sep 06 10:48:00 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3ae6c36f9975992cea6f61d82a0f783b17a87e9c [^]

Fixes Issue 0024612: Little problem in Price list query

---
M src/org/openbravo/retail/posterminal/POSUtils.java
---
(0061040)
hgbot   
2013-09-10 09:59   
Repository: erp/pmods/org.openbravo.retail.posterminal-levelpricing
Changeset: 3ae6c36f9975992cea6f61d82a0f783b17a87e9c
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Fri Sep 06 10:48:00 2013 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/3ae6c36f9975992cea6f61d82a0f783b17a87e9c [^]

Fixes Issue 0024612: Little problem in Price list query

---
M src/org/openbravo/retail/posterminal/POSUtils.java
---