Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025041Openbravo ERPA. Platformpublic2013-10-29 13:062013-10-30 20:47
Reportermarvintm 
Assigned Tomarvintm 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP29Fixed in Version3.0MP29 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2013-07-10
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/7d6d644b9b9e3b9ca55c7be357af7bb86a257263 [^]
Triggers an Emergency PackNo
Summary0025041: Problem when filtering by a computed column with list reference
DescriptionCurrently there is a problem when trying to filter in the grid by a computed column which has a list reference.

The generated HQL query doesn't include the "_computedColumns" property, and therefore it fails.
Steps To Reproduce- Define a computed column with list reference
- Add a field for this column in a window
- Go to this window, and try to filter by one of the values of the list. Click on reload to force a datasource request. Notice that it fails.
Proposed SolutionA change will be done in the AdvancedQueryBuilder so that it takes into account if the property is computed column, to create the query correctly.
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0024966 closed AugustoMauch If you set a sumary function on the grid for a computed column it fails 
related to defect 00252483.0MP31 closed alostale Error after sorting by a computed column 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-10-29 13:06marvintmNew Issue
2013-10-29 13:06marvintmAssigned To => marvintm
2013-10-29 13:06marvintmModules => Core
2013-10-29 13:06marvintmTriggers an Emergency Pack => No
2013-10-29 13:10marvintmReview Assigned To => AugustoMauch
2013-10-29 13:10marvintmRegression level => Production - Confirmed Stable
2013-10-29 13:10marvintmRegression date => 2013-07-10
2013-10-29 13:10marvintmRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7d6d644b9b9e3b9ca55c7be357af7bb86a257263 [^]
2013-10-29 13:12hgbotCheckin
2013-10-29 13:12hgbotNote Added: 0061936
2013-10-29 13:12hgbotStatusnew => resolved
2013-10-29 13:12hgbotResolutionopen => fixed
2013-10-29 13:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/67e80e28874b0d93cd69094cec39febc89a03b11 [^]
2013-10-29 13:17AugustoMauchNote Added: 0061938
2013-10-29 13:17AugustoMauchStatusresolved => closed
2013-10-29 13:17AugustoMauchFixed in Version => 3.0MP29
2013-10-29 23:39AugustoMauchRelationship addedhas duplicate 0024966
2013-10-30 20:47hudsonbotCheckin
2013-10-30 20:47hudsonbotNote Added: 0061982
2013-12-19 16:56alostaleRelationship addedrelated to 0025248

Notes
(0061936)
hgbot   
2013-10-29 13:12   
Repository: erp/devel/pi
Changeset: 67e80e28874b0d93cd69094cec39febc89a03b11
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Oct 29 13:12:22 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/67e80e28874b0d93cd69094cec39febc89a03b11 [^]

Fixed issue 25041. Computed columns with list references will now work correctly when the user filters by them in the grid.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0061938)
AugustoMauch   
2013-10-29 13:17   
Code reviewed and verified in pi@67e80e28874b
(0061982)
hudsonbot   
2013-10-30 20:47   
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/80f375c041fe [^]

Maturity status: Test