Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022777Retail ModulesRetail Widgetspublic2013-01-11 10:232013-01-25 13:13
Reporterjecharri 
Assigned Toguilleaer 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product VersionRMP17 
Target VersionRMP19Fixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022777: The widget "best selling store" is not working properly
DescriptionThe widget "best selling store" is not working properly.

When you say to filter between 11/01/2013 and 11/01/2013 you will that it is impossible to see nothing.

Steps To Reproduce-
Proposed SolutionIf you review to query, you will see next statement:

and o.creationDate>to_date(:datefrom,'YYYY-MM-DD')
and o.creationDate<to_date(:dateto,'YYYY-MM-DD')

and it should be

and o.creationDate>to_date(:datefrom,'YYYY-MM-DD')
and o.creationDate + 1_day <to_date(:dateto,'YYYY-MM-DD')
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-01-11 10:23jecharriNew Issue
2013-01-11 10:23jecharriAssigned To => guilleaer
2013-01-11 10:23jecharriOBNetwork customer => Yes
2013-01-11 10:23jecharriResolution time => 1332198000
2013-01-11 15:09hgbotCheckin
2013-01-11 15:09hgbotNote Added: 0055490
2013-01-11 15:09hgbotStatusnew => resolved
2013-01-11 15:09hgbotResolutionopen => fixed
2013-01-11 15:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.widgets/rev/67593cda8bc2e9b4d7f0891092bd7d21e4eb0e7d [^]
2013-01-25 13:13marvintmReview Assigned To => marvintm
2013-01-25 13:13marvintmStatusresolved => closed

Notes
(0055490)
hgbot   
2013-01-11 15:09   
Repository: erp/pmods/org.openbravo.retail.widgets
Changeset: 67593cda8bc2e9b4d7f0891092bd7d21e4eb0e7d
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Fri Jan 11 14:52:26 2013 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.widgets/rev/67593cda8bc2e9b4d7f0891092bd7d21e4eb0e7d [^]

fixed issue 22777: Best selling store widget is working fine when the period is one day

---
M src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
---