Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023203Openbravo ERPA. Platformpublic2013-03-01 10:222013-03-04 11:13
Reportermalsasua 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version3.0MP21 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2013-01-25
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/d0d2ca046bbb2b054d43a31a4cba76d02949e4e0 [^]
Triggers an Emergency PackNo
Summary0023203: filter does not work with creation date fields
DescriptionIn grid mode, if you try apply a filter in a "creation date" column, error is returned
Steps To Reproduce. go to "user" window
. in grid mode, apply the next filter in "creation date" column:
 . from date: 16-01-2013
 . to date: 16-01-2013

Error:
Invalid filter value 2013-01-16.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0037079 closed caristu more records than expected are fetched when filtering by date ranges 
related to design defect 0040794 new Triage Platform Base Is not possible to filter a DateTime column by time 
related to defect 0040802 closed caristu Use as filter option is not working properly with date columns 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-01 10:22malsasuaNew Issue
2013-03-01 10:22malsasuaAssigned To => AugustoMauch
2013-03-01 10:22malsasuaWeb browser => Google Chrome
2013-03-01 10:22malsasuaModules => Core
2013-03-01 10:22malsasuaOBNetwork customer => No
2013-03-01 10:22malsasuaTriggers an Emergency Pack => No
2013-03-01 13:17AugustoMauchIssue Monitored: shankarb
2013-03-01 13:18AugustoMauchWeb browserGoogle Chrome => Google Chrome
2013-03-01 13:18AugustoMauchRegression level => Production - QA Approved
2013-03-01 13:18AugustoMauchRegression date => 2013-01-25
2013-03-01 13:18AugustoMauchRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/d0d2ca046bbb2b054d43a31a4cba76d02949e4e0 [^]
2013-03-01 13:18AugustoMauchReview Assigned To => shankarb
2013-03-01 13:18AugustoMauchWeb browserGoogle Chrome => Google Chrome
2013-03-01 13:39hgbotCheckin
2013-03-01 13:39hgbotNote Added: 0056897
2013-03-01 13:39hgbotStatusnew => resolved
2013-03-01 13:39hgbotResolutionopen => fixed
2013-03-01 13:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/64b9dc19a8d35fd10617e15e738a06e55c357b67 [^]
2013-03-02 05:48hudsonbotCheckin
2013-03-02 05:48hudsonbotNote Added: 0056948
2013-03-04 11:13shankarbNote Added: 0056981
2013-03-04 11:13shankarbStatusresolved => closed
2013-03-04 11:13shankarbFixed in Version => 3.0MP21
2017-11-28 12:48caristuRelationship addedrelated to 0037079
2019-05-07 11:21caristuRelationship addedrelated to 0040794
2019-05-20 16:25caristuRelationship addedrelated to 0040802

Notes
(0056897)
hgbot   
2013-03-01 13:39   
Repository: erp/devel/pi
Changeset: 64b9dc19a8d35fd10617e15e738a06e55c357b67
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Fri Mar 01 13:37:03 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/64b9dc19a8d35fd10617e15e738a06e55c357b67 [^]

Fixes issue 23203: Filter works with DateTime fields

With the fix of https://issues.openbravo.com/view.php?id=22885, [^] when a Date or DateTime column is filtered, plain Dates are send as criteria. This is done to prevent Date from being converted to its UTC format. The AdvancedQueryBuilder was not prepared for this change, and was expecting a full Date and Time value for DateTime columns. Now it first try to parse the value as a DateTime and if it's not possible it tries to parse the value as a Date.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0056948)
hudsonbot   
2013-03-02 05:48   
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/f5db629e7058 [^]

Maturity status: Test
(0056981)
shankarb   
2013-03-04 11:13   
Code reviewed and verified in pi changeset c0bbe5ba062a.