Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025008Openbravo ERPA. Platformpublic2013-10-24 11:172013-11-27 16:42
Reporterjecharri 
Assigned Toshankarb 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP30Fixed in Version3.0MP30 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket24162
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025008: Sql error using summary functions
DescriptionSql error using summary functions
Steps To Reproduce-Go to window product
-Add "count summary function" to column organization
-Press in the product name with mouse right button and use as filter

After that press in refresh button. You will get error
Exception when creating query select count(join_0.name) from Product as e where ( ( upper(e.name) like :alias_0 escape '|' ) ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-10-24 11:17jecharriNew Issue
2013-10-24 11:17jecharriAssigned To => AugustoMauch
2013-10-24 11:17jecharriWeb browser => Google Chrome
2013-10-24 11:17jecharriModules => Core
2013-10-24 11:17jecharriOBNetwork customer => Yes
2013-10-24 11:17jecharriSupport ticket => 24162
2013-10-24 11:17jecharriResolution time => 1385420400
2013-10-24 11:17jecharriTriggers an Emergency Pack => No
2013-11-18 08:33shankarbAssigned ToAugustoMauch => shankarb
2013-11-20 05:40shankarbReview Assigned To => AugustoMauch
2013-11-20 05:40shankarbWeb browserGoogle Chrome => Google Chrome
2013-11-20 05:40shankarbIssue Monitored: AugustoMauch
2013-11-20 06:58hgbotCheckin
2013-11-20 06:58hgbotNote Added: 0062274
2013-11-20 06:58hgbotStatusnew => resolved
2013-11-20 06:58hgbotResolutionopen => fixed
2013-11-20 06:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fc433509a3e64c04de815f3bb0cf83dc437783fd [^]
2013-11-21 15:46hudsonbotCheckin
2013-11-21 15:46hudsonbotNote Added: 0062333
2013-11-27 16:42AugustoMauchNote Added: 0062418
2013-11-27 16:42AugustoMauchStatusresolved => closed
2013-11-27 16:42AugustoMauchFixed in Version => 3.0MP30

Notes
(0062274)
hgbot   
2013-11-20 06:58   
Repository: erp/devel/pi
Changeset: fc433509a3e64c04de815f3bb0cf83dc437783fd
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Wed Nov 20 11:17:17 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/fc433509a3e64c04de815f3bb0cf83dc437783fd [^]

Fixes Issue 0025008: Sql error using summary function

Handled cases where if the select part contains a summary function, the query builder fails
as the join values are not properly replaced.
Added a new private method replaceJoinsWithValue to replace appropriate value.

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0062333)
hudsonbot   
2013-11-21 15:46   
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/44d0ece7c5ab [^]

Maturity status: Test
(0062418)
AugustoMauch   
2013-11-27 16:42   
Code reviewed and verified in pi@37745290efe5