Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0029741 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] A. Platform | minor | always | 2015-04-29 19:20 | 2022-02-01 08:09 | ||||||
| Reporter | caristu | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Merge Request Status | |||||||||||
| Review Assigned To | |||||||||||
| OBNetwork customer | OBPS | ||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Support ticket | 34860 | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0029741: Summarize fields are not displayed in widgets when the query contains subqueries or uses functions | ||||||||||
| Description | Summarize fields are not displayed in widgets when the query contains subqueries or uses functions. The following error is displayed in the log: 303201 [http-8082-1] ERROR org.openbravo.client.querylist.QueryListDataSource - Exception while fetching the summary columns of the widget: .... It is not supported using as summaries columns that are defined using a subquery, or that are defined using a summary function. But this is appearing even if the summary field is not related to the column that indeed uses the subquery. | ||||||||||
| Steps To Reproduce | 1) Install the following module: https://code.openbravo.com/erp/mods/com.openbravo.support.test/ [^] 2) Add the "Test Widget: totals and subqueries" widget to the workspace 3) Notice that the summary field is not appearing and the error message is displayed in the log | ||||||||||
| Proposed Solution | It seems that the updateHQLWithSummaryFields of the QueryListDataSource is not parsing correctly the hql query in this cases | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-04-29 19:20 | caristu | New Issue | |
| 2015-04-29 19:20 | caristu | Assigned To | => platform |
| 2015-04-29 19:20 | caristu | OBNetwork customer | => Yes |
| 2015-04-29 19:20 | caristu | Modules | => Core |
| 2015-04-29 19:20 | caristu | Support ticket | => 34860 |
| 2015-04-29 19:20 | caristu | Triggers an Emergency Pack | => No |
| 2015-04-29 19:30 | caristu | Issue Monitored: networkb | |
| 2015-04-29 19:30 | caristu | Summary | 29174: Summarize fields are not displayed in widgets when the query contains subqueries or uses functions => Summarize fields are not displayed in widgets when the query contains subqueries or uses functions |
| 2015-04-29 20:18 | hgbot | Checkin | |
| 2015-04-29 20:18 | hgbot | Note Added: 0076893 | |
| 2015-04-29 20:19 | hgbot | Checkin | |
| 2015-04-29 20:19 | hgbot | Note Added: 0076895 | |
| 2015-04-29 20:19 | caristu | Relationship added | caused by 0029174 |
| 2015-04-29 20:20 | caristu | Note Deleted: 0076893 | |
| 2015-04-29 20:20 | caristu | Note Deleted: 0076895 | |
| 2015-11-10 14:58 | alostale | Status | new => acknowledged |
| 2015-11-11 11:37 | alostale | Priority | high => normal |
| 2016-04-05 17:21 | alostale | Type | defect => design defect |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |