Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020464Openbravo ERP00. Application dictionarypublic2012-05-10 10:132012-09-24 12:55
Reportermalsasua 
Assigned Tomigueldejuana 
PrioritynormalSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020464: filter in widget with column date
Descriptionif you configure a column type date as a filter, this filter only allow select one date. It is not posible select a date from and date to

[1] http://wiki.openbravo.com/wiki/How_to_create_a_QueryList_Widget [^]
Steps To Reproducecreate widget with column type date checked as filter

http://wiki.openbravo.com/wiki/How_to_create_a_QueryList_Widget [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0020462 closed migueldejuana widget with column type "yesno" does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-10 10:13malsasuaNew Issue
2012-05-10 10:13malsasuaAssigned To => alostale
2012-05-10 10:13malsasuaWeb browser => Google Chrome
2012-05-10 10:13malsasuaModules => Core
2012-05-10 10:13malsasuaOBNetwork customer => Yes
2012-05-10 10:50alostaleRelationship addedrelated to 0020462
2012-05-10 10:52alostaleAssigned Toalostale => migueldejuana
2012-05-10 17:33migueldejuanaNote Added: 0048560
2012-05-16 15:37migueldejuanaWeb browserGoogle Chrome => Google Chrome
2012-05-16 15:37migueldejuanaNote Added: 0048702
2012-05-16 15:37migueldejuanaTypedefect => design defect
2012-09-24 12:55AugustoMauchWeb browserGoogle Chrome => Google Chrome
2012-09-24 12:55AugustoMauchNote Added: 0052337
2012-09-24 12:55AugustoMauchPriorityhigh => normal
2012-09-24 12:55AugustoMauchStatusnew => scheduled

Notes
(0048560)
migueldejuana   
2012-05-10 17:33   
It only allows select one date because it was changed in this changeset:

https://code.openbravo.com/erp/devel/pi/rev/aa2b3099cb9d#l4.7 [^]
(0048702)
migueldejuana   
2012-05-16 15:37   
Afair the problem was that the querylistwidget has its own implementation of handling filter criteria. The normal grid can handle advanced criteria/filter-criteria expressions. The query list widget implementation can only handle simple criteria.

If the date range filtering is enabled on the query list widget then Smartclient switches to advanced criteria mode. To prevent this I disabled forced the usage of the date range filtering.

The query list data source can't handle this, see the method here: QueryListDataSource.parseOptionalFilters

Note that imv this is not a defect, but a 'design defect' or a missing feature.

To solve this it would be much better if the query list widget would make use of the AdvancedQueryBuilder class which can handle advanced criteria. But this is some work....
(0052337)
AugustoMauch   
2012-09-24 12:55   
Effort: 5
Impact: mid
Plan: mid