0029741: Summarize fields are not displayed in widgets when the query contains subqueries or uses functions

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0029741

Openbravo ERP

A. Platform

public

2015-04-29 19:20

2022-02-01 08:09

Reporter

caristu

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

always

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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

Additional Information