Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023200
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2013-03-01 08:502013-03-13 10:13
ReportervmromanosView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version3.0MP22
StatusclosedFix in branchpiFixed in SCM revision75cf7457df9c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionDebian 5.0Database version8.3.8Ant version1.7.0
Product VersionpiSCM revision 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023200: 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
TagsNo tags attached.
Attached Files? file icon issue23200.export [^] (2,168 bytes) 2013-03-05 12:20

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0024012 closedAugustoMauch Problem with query list widgets with boolean columns 

-  Notes
(0057127)
hgbot (developer)
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 (administrator)
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 (viewer)
2013-03-13 10:13

 Code Reviewed and verified in pi changeset 82a9b1ee6ccf.

- Issue History
Date Modified Username Field Change
2013-03-01 08:50 vmromanos New Issue
2013-03-01 08:50 vmromanos Assigned To => AugustoMauch
2013-03-01 08:50 vmromanos Modules => Core
2013-03-01 08:50 vmromanos OBNetwork customer => No
2013-03-01 08:50 vmromanos Triggers an Emergency Pack => No
2013-03-05 12:20 AugustoMauch File Added: issue23200.export
2013-03-05 12:21 AugustoMauch Status new => scheduled
2013-03-05 12:21 AugustoMauch fix_in_branch => pi
2013-03-07 12:22 hgbot Checkin
2013-03-07 12:22 hgbot Note Added: 0057127
2013-03-07 12:22 hgbot Status scheduled => resolved
2013-03-07 12:22 hgbot Resolution open => fixed
2013-03-07 12:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/75cf7457df9c102c24bc8a1e51d67b7eae4cf2b4 [^]
2013-03-07 12:23 AugustoMauch Issue Monitored: shankarb
2013-03-07 12:25 AugustoMauch Review Assigned To => shankarb
2013-03-07 12:28 AugustoMauch Note Added: 0057128
2013-03-13 10:13 shankarb Note Added: 0057220
2013-03-13 10:13 shankarb Status resolved => closed
2013-03-13 10:13 shankarb Fixed in Version => 3.0MP22
2013-06-06 14:48 AugustoMauch Relationship added related to 0024012

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker