Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023200Openbravo ERPA. Platformpublic2013-03-01 08:502013-03-13 10:13
Reportervmromanos 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionDebian 5.0
Product Versionpi 
Target VersionFixed in Version3.0MP22 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023200: YesNo reference not working properly in Query/List widgets
DescriptionWhen defining a YesNo reference for a column in a Query/List widget, the checkbox is always marked in case the column has any value ('Y' or 'N'). The only way for not marking the checkbox is when the column has no value ('').
Steps To ReproduceCreate a query/list widget with a column set as YesNo reference.
The hql can be:
select 'N' as myCheck from Order where ord.client.id = :client

Verify in the widget that the checkbox is marked.

Now try: select '' as myCheck from Order where ord.client.id = :client
The checkbox is not marked
Proposed SolutionIn case of 'N' the checkbox should not be marked
Additional Information
TagsNo tags attached.
Relationships
related to defect 0024012 closed AugustoMauch Problem with query list widgets with boolean columns 
Attached Files? issue23200.export (2,168) 2013-03-05 12:20
https://issues.openbravo.com/file_download.php?file_id=6014&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-03-01 08:50vmromanosNew Issue
2013-03-01 08:50vmromanosAssigned To => AugustoMauch
2013-03-01 08:50vmromanosModules => Core
2013-03-01 08:50vmromanosTriggers an Emergency Pack => No
2013-03-05 12:20AugustoMauchFile Added: issue23200.export
2013-03-05 12:21AugustoMauchStatusnew => scheduled
2013-03-05 12:21AugustoMauchfix_in_branch => pi
2013-03-07 12:22hgbotCheckin
2013-03-07 12:22hgbotNote Added: 0057127
2013-03-07 12:22hgbotStatusscheduled => resolved
2013-03-07 12:22hgbotResolutionopen => fixed
2013-03-07 12:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/75cf7457df9c102c24bc8a1e51d67b7eae4cf2b4 [^]
2013-03-07 12:23AugustoMauchIssue Monitored: shankarb
2013-03-07 12:25AugustoMauchReview Assigned To => shankarb
2013-03-07 12:28AugustoMauchNote Added: 0057128
2013-03-13 10:13shankarbNote Added: 0057220
2013-03-13 10:13shankarbStatusresolved => closed
2013-03-13 10:13shankarbFixed in Version => 3.0MP22
2013-06-06 14:48AugustoMauchRelationship addedrelated to 0024012

Notes
(0057127)
hgbot   
2013-03-07 12:22   
Repository: erp/devel/pi
Changeset: 75cf7457df9c102c24bc8a1e51d67b7eae4cf2b4
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Mar 05 12:15:06 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/75cf7457df9c102c24bc8a1e51d67b7eae4cf2b4 [^]

Fixes issue 23200: YesNo columns default value in Query Widgets works properly

The step where the 'N' and 'Y' values of YesNo columns were converted to false and true respectively was missing.

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0057128)
AugustoMauch   
2013-03-07 12:28   
Test plan:
- Check that the problem described in the steps to reproduce does not longer happen
- Check that the already defined Query Widgets that contains YesNo columns with default value keep working
(0057220)
shankarb   
2013-03-13 10:13   
Code Reviewed and verified in pi changeset 82a9b1ee6ccf.