Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020214Openbravo ERPB. User interfacepublic2012-04-05 20:112012-04-20 12:37
Reporterjvazquez 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP11 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020214: Column filter for null dates does not work
DescriptionIf you enter # in a date column in order to look for null values, it does not work and as your hit enter, the # dissapears.
Steps To ReproduceNavigate to any window with a date column/field on it and enter #. Hit enter to filter results. Filtering does not work.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Fileszip org.openbravo.test.issue20214.zip (4,627) 2012-04-16 11:44
https://issues.openbravo.com/file_download.php?file_id=5133&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-04-05 20:11jvazquezNew Issue
2012-04-05 20:11jvazquezAssigned To => dbaz
2012-04-05 20:11jvazquezModules => Core
2012-04-05 20:11jvazquezOBNetwork customer => No
2012-04-05 22:55dbazAssigned Todbaz => AugustoMauch
2012-04-10 19:09jvazquezNote Added: 0047451
2012-04-16 10:57hgbotCheckin
2012-04-16 10:57hgbotNote Added: 0047578
2012-04-16 10:57hgbotStatusnew => resolved
2012-04-16 10:57hgbotResolutionopen => fixed
2012-04-16 10:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/11bda20002ae824cb32563cb7e595c9563334510 [^]
2012-04-16 11:44AugustoMauchNote Added: 0047580
2012-04-16 11:44AugustoMauchStatusresolved => new
2012-04-16 11:44AugustoMauchResolutionfixed => open
2012-04-16 11:44AugustoMauchFile Added: org.openbravo.test.issue20214.zip
2012-04-16 11:44AugustoMauchStatusnew => scheduled
2012-04-16 11:44AugustoMauchfix_in_branch => pi
2012-04-16 11:45AugustoMauchStatusscheduled => resolved
2012-04-16 11:45AugustoMauchFixed in Version => 3.0MP11
2012-04-16 11:45AugustoMauchResolutionopen => fixed
2012-04-16 11:47AugustoMauchNote Added: 0047581
2012-04-17 05:32hudsonbotCheckin
2012-04-17 05:32hudsonbotNote Added: 0047652
2012-04-20 12:37alostaleNote Added: 0047785
2012-04-20 12:37alostaleStatusresolved => closed

Notes
(0047451)
jvazquez   
2012-04-10 19:09   
Hello,
from a user perspective, I should be able to filter date columns in order to get those which do not have a value (value is null). I don't know if we should keep it the same way we do it right now with regular columns (use #) or add a new value to the combo.
Regards,
    Javier
(0047578)
hgbot   
2012-04-16 10:57   
Repository: erp/devel/pi
Changeset: 11bda20002ae824cb32563cb7e595c9563334510
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Apr 16 10:54:41 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/11bda20002ae824cb32563cb7e595c9563334510 [^]

Fixes issue 20214: Date column filtering improved

Now it is possible to enter '#' and '!#' in the filter of the date columns to retrieve the records that do not have a value in that column and the records that do have a value, respectively.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-minidaterange.js
---
(0047580)
AugustoMauch   
2012-04-16 11:44   
Reopened to attach a test module
(0047581)
AugustoMauch   
2012-04-16 11:47   
Test plan:
- Install attached module. It will add a non-mandatory date to the Unit of Measure header tab.
- Enter valid dates in some of the records.
- Enter '#' in the date column filter to select the records that do not have a value in that column, and '!#' to select the records that do have a value.
- Check that you can still enter a date (i.e. 010512) and a range of dates.
(0047652)
hudsonbot   
2012-04-17 05: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/cedf57621434 [^]

Maturity status: Test
(0047785)
alostale   
2012-04-20 12:37   
Code reviewed and tested on pi@89690f42989

Additional executed tests, apart of test described in test plan:
-Filter by not null dates !#
-Ensure no regression by testing previously working filters:
  *Concrete date
  *Date from null, date to with value
  *Date from with value, date to null