Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024012Openbravo ERPA. Platformpublic2013-06-06 14:442013-06-20 02:07
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP25 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2013-03-05
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/75cf7457df9c102c24bc8a1e51d67b7eae4cf2b4 [^]
Triggers an Emergency PackNo
Summary0024012: Problem with query list widgets with boolean columns
DescriptionIf a query list widget has a boolean column whose value is taken from a boolean database column a java.lang.ClassCastException exception is thrown
Steps To Reproduce- Create a query list column, use this hql: select active as myBoolean1, 'N' as myBoolean2 from Product where name = 'Lemonade'
- Define two query YesNo parameters: myBoolean1 and myBoolean2
- Restart tomcat.
- Log in again and add the new widget to the workspace. It will not show any records and a ClassCastException will be thrown in the server
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023200 closed AugustoMauch YesNo reference not working properly in Query/List widgets 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-06-06 14:44AugustoMauchNew Issue
2013-06-06 14:44AugustoMauchAssigned To => AugustoMauch
2013-06-06 14:44AugustoMauchModules => Core
2013-06-06 14:44AugustoMauchOBNetwork customer => No
2013-06-06 14:44AugustoMauchTriggers an Emergency Pack => No
2013-06-06 14:46AugustoMauchRegression level => Production - Confirmed Stable
2013-06-06 14:46AugustoMauchRegression date => 2013-03-05
2013-06-06 14:46AugustoMauchRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/75cf7457df9c102c24bc8a1e51d67b7eae4cf2b4 [^]
2013-06-06 14:47AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4777#r4777
2013-06-06 14:48AugustoMauchRelationship addedrelated to 0023200
2013-06-06 14:48AugustoMauchIssue Monitored: shankarb
2013-06-06 14:49AugustoMauchReview Assigned To => shankarb
2013-06-06 14:51hgbotCheckin
2013-06-06 14:51hgbotNote Added: 0059247
2013-06-06 14:51hgbotStatusnew => resolved
2013-06-06 14:51hgbotResolutionopen => fixed
2013-06-06 14:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/581ac6b950488ffb6c65d682f0e22a1f907adba6 [^]
2013-06-13 08:44shankarbNote Added: 0059406
2013-06-13 08:44shankarbStatusresolved => closed
2013-06-13 08:44shankarbFixed in Version => 3.0MP25
2013-06-20 02:07hudsonbotCheckin
2013-06-20 02:07hudsonbotNote Added: 0059546

Notes
(0059247)
hgbot   
2013-06-06 14:51   
Repository: erp/devel/pi
Changeset: 581ac6b950488ffb6c65d682f0e22a1f907adba6
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Jun 06 14:51:21 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/581ac6b950488ffb6c65d682f0e22a1f907adba6 [^]

Fixes issue 24012: Query list widgets with boolean parameters works

Before trying to convert a 'Y' or 'N' string to boolean in this line [1], check that the value is a string, because sometimes at that point the value attribute can already be a boolean.

[1] https://code.openbravo.com/erp/devel/pi/file/4cd557c40816/modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java#l221 [^]

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0059406)
shankarb   
2013-06-13 08:44   
Code reviewed and verified in pi changeset a148e16b1057
(0059546)
hudsonbot   
2013-06-20 02:07   
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/5caf871044ad [^]

Maturity status: Test