Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018079Openbravo ERPB. User interfacepublic2011-07-26 11:152011-10-12 01:59
Reporterjecharri 
Assigned Tomtaal 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP4Fixed in Version3.0MP4 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket12120
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018079: Date filter is not working correctly
DescriptionDate filter is not working correctly because you can only filter by date ("year-month-day") and the filter is filtering by date and time ("year-month-day hours:minutes:seconds").
So if we want to filter today's lines and we configure filter like:
-from:today
-to:today
and we have one line in BBDD where date is "today 00:00:01" this line is not going to be shown and you will have to configure filter like:
-from:today
-to:tomorrow
Steps To ReproduceGo to BBDD an update the column "dateordered" from "c_order" table and put any time (different to 00:00:00).

Go to sales order or purchase order (it depends of the line you have updated) and try to filter from the day when is the updated order. You will see that the order is not shown.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0018754 closed alostale filter "date to" in column "date ordered" in sales order does not work 
related to defect 0037079 closed caristu more records than expected are fetched when filtering by date ranges 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-26 11:15jecharriNew Issue
2011-07-26 11:15jecharriAssigned To => dbaz
2011-07-26 11:15jecharriWeb browser => Google Chrome
2011-07-26 11:15jecharriModules => Core
2011-07-26 11:15jecharriOBNetwork customer => Yes
2011-07-26 11:15jecharriSupport ticket => 12120
2011-07-26 11:15jecharriResolution time => 1318370400
2011-07-26 14:18dbazAssigned Todbaz => mtaal
2011-08-31 09:45mtaalWeb browserGoogle Chrome => Google Chrome
2011-08-31 09:45mtaalTarget Version3.0MP3 => 3.0MP4
2011-09-20 19:09hgbotCheckin
2011-09-20 19:09hgbotNote Added: 0041158
2011-09-20 19:09hgbotStatusnew => resolved
2011-09-20 19:09hgbotResolutionopen => fixed
2011-09-20 19:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6f3c663497e96a85ef705e03b355e1c0a084e26e [^]
2011-09-21 23:23mtaalNote Added: 0041223
2011-09-21 23:23mtaalStatusresolved => new
2011-09-21 23:23mtaalResolutionfixed => open
2011-09-23 06:58hgbotCheckin
2011-09-23 06:58hgbotNote Added: 0041244
2011-09-23 06:58hgbotStatusnew => resolved
2011-09-23 06:58hgbotResolutionopen => fixed
2011-09-23 06:58hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6f3c663497e96a85ef705e03b355e1c0a084e26e [^] => http://code.openbravo.com/erp/devel/pi/rev/c0f00abf9563bdcda8f1af8357b6b18f1b9c8ed3 [^]
2011-09-23 08:48jecharriNote Added: 0041253
2011-09-23 08:48jecharriStatusresolved => closed
2011-09-23 08:48jecharriFixed in Version => 3.0MP4
2011-10-12 01:59hudsonbotCheckin
2011-10-12 01:59hudsonbotNote Added: 0041690
2011-10-12 01:59hudsonbotCheckin
2011-10-12 01:59hudsonbotNote Added: 0041697
2011-10-17 17:34malsasuaRelationship addedhas duplicate 0018754
2017-11-28 11:02caristuRelationship addedrelated to 0037079

Notes
(0041158)
hgbot   
2011-09-20 19:09   
Repository: erp/devel/pi
Changeset: 6f3c663497e96a85ef705e03b355e1c0a084e26e
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Sep 20 19:08:40 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6f3c663497e96a85ef705e03b355e1c0a084e26e [^]

Fixes issue 18079: Date filter is not working correctly
When working with a range of dates, set the time to 0 or 24 hours

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0041223)
mtaal   
2011-09-21 23:23   
Need to test and solve if filtering is done on one day
(0041244)
hgbot   
2011-09-23 06:58   
Repository: erp/devel/pi
Changeset: c0f00abf9563bdcda8f1af8357b6b18f1b9c8ed3
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Fri Sep 23 06:58:04 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c0f00abf9563bdcda8f1af8357b6b18f1b9c8ed3 [^]

Fixes issue 18079: Date filter is not working correctly
Now also handle filtering on one date correctly

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0041253)
jecharri   
2011-09-23 08:48   
Tested and working
(0041690)
hudsonbot   
2011-10-12 01:59   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9bd2b5c2d982 [^]

Maturity status: Test
(0041697)
hudsonbot   
2011-10-12 01:59   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9bd2b5c2d982 [^]

Maturity status: Test