Openbravo Issue Tracking System - Retail Modules
View Issue Details
0022777Retail ModulesRetail Widgetspublic2013-01-11 10:232013-01-25 13:13
jecharri 
guilleaer 
urgentminoralways
closedfixed 
5
RMP17 
RMP19 
marvintm
No
0022777: The widget "best selling store" is not working properly
The 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.

-
If 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')
No tags attached.
Issue History
2013-01-11 10:23jecharriNew Issue
2013-01-11 10:23jecharriAssigned To => guilleaer
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
---