Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025915Openbravo ERPB. User interfacepublic2014-03-05 23:272014-05-19 13:46
dbaz 
guillermogil 
highmajoralways
closedunable to reproduce 
5
 
pi 
AugustoMauch
Core
No
0025915: Problem in grid while trying to filter "DateTime" references
Problem in grid while trying to filter "DateTime" references
Here it is a video showing how can it be reproduced:
http://screencast.com/t/8Y5nlEf5T [^]

The module "org.openbravo.platform.features" is needed.

Server: Spanish timezone GMT+1
Client: San Francisco timezone GMT-5
Client date: 27-Feb-2014 20:00:00 GMT-5

As "Openbravo Admin":
* Go to "Sales Order"
* Create a new record with:
   - Absolute Date-Time: "26-02-2014 23:59:59"
   - Relative Date-Time: "26-02-2014 23:59:59"
* Go to grid view to test some filters:

a) In "Absolute Date-Time" filter from "Today" to "Tomorrow". As expected: no rows are returned.
b) In "Absolute Date-Time" filter from "Yesterday" to "Today". As expected: it returns the recent created register.

c) In "Relative Date-Time" filter from "Today" to "Tomorrow". It is wrong: it returns the recent created register and it shouldn't.
d) In "Absolute Date-Time" filter from "Yesterday" to "Today". As expected, it returns the recent created register.

e) In "Absolute Date-Time" filter from "27-02-2014" to "27-02-2014". As expected: no rows are returned.
f) In "Absolute Date-Time" filter from "26-02-2014" to "26-02-2014". As expected: it returns the recent created register.

e) In "Relative Date-Time" filter from "27-02-2014" to "27-02-2014". It is wrong: it returns the recent created register and it shouldn't.
f) In "Relative Date-Time" filter from "26-02-2014" to "26-02-2014". It is wrong: it doesn't return anything and it should return the recent created register and it shouldn't.

As you can see, the problem is with "c" "e" and "f" cases, but after the fix, the test should ensure that all cases work ok.
No tags attached.
Issue History
2014-03-05 23:27dbazNew Issue
2014-03-05 23:27dbazAssigned To => AugustoMauch
2014-03-05 23:27dbazModules => Core
2014-03-05 23:27dbazTriggers an Emergency Pack => No
2014-03-05 23:28dbazNote Added: 0064873
2014-03-05 23:28dbazIssue Monitored: dbaz
2014-05-19 13:36guillermogilAssigned ToAugustoMauch => guillermogil
2014-05-19 13:46guillermogilReview Assigned To => AugustoMauch
2014-05-19 13:46guillermogilNote Added: 0067255
2014-05-19 13:46guillermogilStatusnew => closed
2014-05-19 13:46guillermogilResolutionopen => unable to reproduce
2014-05-19 13:46guillermogilFixed in Version => pi

Notes
(0064873)
dbaz   
2014-03-05 23:28   
The issue already happens before [scupgrade] and [absref] were merged.
(0067255)
guillermogil   
2014-05-19 13:46   
This behavior has been fixed on https://code.openbravo.com/erp/devel/pi/rev/2fa563c7719d157d7903f91a7f638daf2ee8a495 [^]