Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018079
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] B. User interfaceminoralways2011-07-26 11:152011-10-12 01:59
ReporterjecharriView Statuspublic 
Assigned Tomtaal 
PriorityhighResolutionfixedFixed in Version3.0MP4
StatusclosedFix in branchFixed in SCM revisionc0f00abf9563
ProjectionnoneETAnoneTarget Version3.0MP4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
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
Summary

0018079: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0018754 closedalostale filter "date to" in column "date ordered" in sales order does not work 
related to defect 0037079 closedcaristu more records than expected are fetched when filtering by date ranges 

-  Notes
(0041158)
hgbot (developer)
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 (viewer)
2011-09-21 23:23

 Need to test and solve if filtering is done on one day
(0041244)
hgbot (developer)
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 (viewer)
2011-09-23 08:48

 Tested and working
(0041690)
hudsonbot (viewer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2011-07-26 11:15 jecharri New Issue
2011-07-26 11:15 jecharri Assigned To => dbaz
2011-07-26 11:15 jecharri Web browser => Google Chrome
2011-07-26 11:15 jecharri Modules => Core
2011-07-26 11:15 jecharri OBNetwork customer => Yes
2011-07-26 11:15 jecharri Support ticket => 12120
2011-07-26 11:15 jecharri Resolution time => 1318370400
2011-07-26 14:18 dbaz Assigned To dbaz => mtaal
2011-08-31 09:45 mtaal Web browser Google Chrome => Google Chrome
2011-08-31 09:45 mtaal Target Version 3.0MP3 => 3.0MP4
2011-09-20 19:09 hgbot Checkin
2011-09-20 19:09 hgbot Note Added: 0041158
2011-09-20 19:09 hgbot Status new => resolved
2011-09-20 19:09 hgbot Resolution open => fixed
2011-09-20 19:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6f3c663497e96a85ef705e03b355e1c0a084e26e [^]
2011-09-21 23:23 mtaal Note Added: 0041223
2011-09-21 23:23 mtaal Status resolved => new
2011-09-21 23:23 mtaal Resolution fixed => open
2011-09-23 06:58 hgbot Checkin
2011-09-23 06:58 hgbot Note Added: 0041244
2011-09-23 06:58 hgbot Status new => resolved
2011-09-23 06:58 hgbot Resolution open => fixed
2011-09-23 06:58 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6f3c663497e96a85ef705e03b355e1c0a084e26e [^] => http://code.openbravo.com/erp/devel/pi/rev/c0f00abf9563bdcda8f1af8357b6b18f1b9c8ed3 [^]
2011-09-23 08:48 jecharri Note Added: 0041253
2011-09-23 08:48 jecharri Status resolved => closed
2011-09-23 08:48 jecharri Fixed in Version => 3.0MP4
2011-10-12 01:59 hudsonbot Checkin
2011-10-12 01:59 hudsonbot Note Added: 0041690
2011-10-12 01:59 hudsonbot Checkin
2011-10-12 01:59 hudsonbot Note Added: 0041697
2011-10-17 17:34 malsasua Relationship added has duplicate 0018754
2017-11-28 11:02 caristu Relationship added related to 0037079

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker