Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023582Openbravo ERPB. User interfacepublic2013-04-18 17:122015-02-24 11:27
Reporterdbaz 
Assigned ToAugustoMauch 
PriorityhighSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todbaz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023582: DateTime query list widget filter columns doesn't work
DescriptionDateTime query list widget filter columns doesn't work
Steps To ReproduceCreate a new query list widget and ensure that at least one of its columns has DataTime as its reference.

Also, for this column, add filtering capacity.

Open the widget, maximize it and try to filter by the datetime column.

PS: If you are familiarized with org.openbravo.module.resources module, you can install it and create a reservation. Then in the widget "All Reservations" you have a couple of columns (DateTime From and DateTime To) with a DateTime reference.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023308 closed AugustoMauch It is not possible to filter a Time column in Query Widgets 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-04-18 17:12dbazNew Issue
2013-04-18 17:12dbazAssigned To => AugustoMauch
2013-04-18 17:12dbazModules => Core
2013-04-18 17:12dbazTriggers an Emergency Pack => No
2013-04-18 17:13AugustoMauchRelationship addedrelated to 0023308
2013-07-24 17:33AugustoMauchIssue Monitored: dbaz
2013-07-24 17:33AugustoMauchReview Assigned To => dbaz
2013-07-24 17:35hgbotCheckin
2013-07-24 17:35hgbotNote Added: 0060277
2013-07-24 17:35hgbotStatusnew => resolved
2013-07-24 17:35hgbotResolutionopen => fixed
2013-07-24 17:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e64fce34e4c2533c079af6b7ed086916394b101d [^]
2013-07-24 20:49dbazNote Added: 0060291
2013-07-24 20:49dbazStatusresolved => new
2013-07-24 20:49dbazResolutionfixed => open
2013-07-26 20:32hudsonbotCheckin
2013-07-26 20:32hudsonbotNote Added: 0060314
2014-05-23 11:26alostaleSeveritymajor => minor
2015-02-24 11:26alostaleTypedefect => design defect
2015-02-24 11:27alostaleNote Added: 0074836

Notes
(0060277)
hgbot   
2013-07-24 17:35   
Repository: erp/devel/pi
Changeset: e64fce34e4c2533c079af6b7ed086916394b101d
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Jul 24 17:33:02 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e64fce34e4c2533c079af6b7ed086916394b101d [^]

Fixes issue 23582: DateTime query list widget filter columns works

In this changeset [1] a change was done to enable filtering Time columns in QueryList widgets. This issue has been fixed by applying the same approach to the DateTime columns.

[1] https://code.openbravo.com/erp/devel/pi/rev/6f316468c5e7ad4658488e3bc0791544b49965c1 [^]

---
M modules/org.openbravo.userinterface.smartclient/web/org.openbravo.userinterface.smartclient/js/ob-smartclient.js
---
(0060291)
dbaz   
2013-07-24 20:49   
The fix doesn't work. I can not still enter any datetime (date + TIME) in the grid filter. If I enter just a date it works "ok", but if I add the time part, the value gets cleared (the same that if I introduce a not valid value)

It can be reproduced following the "PS" of the 'Steps to Reproduce' section
(0060314)
hudsonbot   
2013-07-26 20:32   
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/b9e43ea5aa1b [^]

Maturity status: Test
(0074836)
alostale   
2015-02-24 11:27   
moves to design defect: requires to implement missing functionality