Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011476Openbravo ERPA. Platformpublic2009-11-24 14:172009-12-16 16:47
Reporterpjuvara 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP7 
Target Version2.50MP12Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011476: Checkboxes do not work properly as filters
DescriptionIt is not possible to execute a proper search based on the value of a check box.

If in a table you have a column with reference YesNo, in the corresponding windows that column is rendered as a checkbox in the Form view and as a Y | N in the Grid view.

If you also mark that column as a filter (checkbox Filter Column checked), it is rendered in the Filter window as a check box.
The problem is that this does not allow you to specify the proper filter criteria:
* If you leave the box unchecked, all records are returned
* If you check the box, only records where the box is checked are returned
However, you cannot search for records where the box is unchecked.

For example, in the Business Partner window, you can search for all business partners that are customers but you cannot search for all business partners that are not partners.

Steps To ReproduceIn the Business Partner window, you can search for all business partners that are customers but you cannot search for all business partners that are not partners.
Proposed SolutionA column with reference should be rendered in a filter window as a drop-down list control with the possible value:
- Yes
- No
- Any
Any should be selected by default.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-24 14:17pjuvaraNew Issue
2009-11-24 14:17pjuvaraAssigned To => rafaroda
2009-12-07 20:17psarobeAssigned Torafaroda => alostale
2009-12-07 20:17psarobeStatusnew => scheduled
2009-12-07 20:17psarobeTarget Version => 2.50MP12
2009-12-15 09:08hgbotCheckin
2009-12-15 09:08hgbotNote Added: 0022805
2009-12-15 09:08hgbotStatusscheduled => resolved
2009-12-15 09:08hgbotResolutionopen => fixed
2009-12-15 09:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/088711d8ca94d165701b592827d3b6f6d0baf61a [^]
2009-12-15 09:10alostaleNote Added: 0022806
2009-12-15 09:29iperdomoStatusresolved => new
2009-12-15 09:29iperdomoResolutionfixed => open
2009-12-15 09:29iperdomoStatusnew => scheduled
2009-12-15 09:29iperdomofix_in_branch => pi
2009-12-15 09:29hgbotCheckin
2009-12-15 09:29hgbotNote Added: 0022810
2009-12-15 09:29hgbotStatusscheduled => resolved
2009-12-15 09:29hgbotResolutionopen => fixed
2009-12-15 09:29hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/088711d8ca94d165701b592827d3b6f6d0baf61a [^] => http://code.openbravo.com/erp/devel/pi/rev/c758c001cc3b1d908086cd0152631ad60970fc7d [^]
2009-12-15 09:33iperdomoStatusresolved => new
2009-12-15 09:33iperdomoResolutionfixed => open
2009-12-15 09:33iperdomoStatusnew => scheduled
2009-12-15 09:57hgbotCheckin
2009-12-15 09:57hgbotNote Added: 0022811
2009-12-15 09:57hgbotStatusscheduled => resolved
2009-12-15 09:57hgbotResolutionopen => fixed
2009-12-15 09:57hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/c758c001cc3b1d908086cd0152631ad60970fc7d [^] => http://code.openbravo.com/erp/devel/pi/rev/dfac781730a9e84a8476cbcd4cfb308cc457cab8 [^]
2009-12-15 10:03iperdomoNote Added: 0022812
2009-12-15 10:03iperdomoStatusresolved => closed
2009-12-16 00:00anonymoussf_bug_id0 => 2915146
2009-12-16 16:46hudsonbotCheckin
2009-12-16 16:46hudsonbotNote Added: 0022867
2009-12-16 16:46hudsonbotCheckin
2009-12-16 16:46hudsonbotNote Added: 0022868
2009-12-16 16:47hudsonbotCheckin
2009-12-16 16:47hudsonbotNote Added: 0022869

Notes
(0022805)
hgbot   
2009-12-15 09:08   
Repository: erp/devel/pi
Changeset: 088711d8ca94d165701b592827d3b6f6d0baf61a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Dec 15 09:08:05 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/088711d8ca94d165701b592827d3b6f6d0baf61a [^]

fixed bug 0011476: Checkboxes do not work properly as filters

---
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/erpCommon/businessUtility/Buscador.java
---
(0022806)
alostale   
2009-12-15 09:10   
Implemented as a drop down list.

As the rest of drop down list for filters, there is an empty value that removes the filter when selected (instead of the explicit "any" value").
(0022810)
hgbot   
2009-12-15 09:29   
Repository: erp/devel/pi
Changeset: c758c001cc3b1d908086cd0152631ad60970fc7d
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Dec 15 09:29:32 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c758c001cc3b1d908086cd0152631ad60970fc7d [^]

fixed bug 0011476: Checkboxes do not work properly as filters

---
M src/org/openbravo/erpCommon/businessUtility/Buscador.java
---
(0022811)
hgbot   
2009-12-15 09:57   
Repository: erp/devel/pi
Changeset: dfac781730a9e84a8476cbcd4cfb308cc457cab8
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Dec 15 09:57:04 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dfac781730a9e84a8476cbcd4cfb308cc457cab8 [^]

fixed bug 0011476: Checkboxes do not work properly as filters

---
M src/org/openbravo/erpCommon/businessUtility/Buscador.java
---
(0022812)
iperdomo   
2009-12-15 10:03   
Tested on pi @ dfac781730a9
(0022867)
hudsonbot   
2009-12-16 16:46   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/088711d8ca94 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/1767de909fe7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15751.obx [^]
---
(0022868)
hudsonbot   
2009-12-16 16:46   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/c758c001cc3b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/1767de909fe7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15751.obx [^]
---
(0022869)
hudsonbot   
2009-12-16 16:47   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/dfac781730a9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/1767de909fe7 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15751.obx [^]
---