Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0038844 | Openbravo ERP | A. Platform | public | 2018-06-26 16:59 | 2022-02-01 08:08 |
| Reporter | joniturralde93 | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| 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 | No | ||||
| Summary | 0038844: Aggregate functions as new columns cannot be filtered in grid (HQL based table) | ||||
| Description | If a HQL based table is created with a column defined by an aggregate function (Sum(), Average(), Count()...), if you try to filter by that column in grid view, an error appears: ERROR could not execute query Also this error can be found: ERROR: aggregate functions are not allowed in WHERE | ||||
| Steps To Reproduce | - Create a HQL based table which contains a column defined by an aggregate function and create its columns. - Create a Window and Tab with its fields. - Open the tab and filter by that column value. - An error is thrown and no results appear. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2018-06-26 16:59 | joniturralde93 | New Issue | |||
| 2018-06-26 16:59 | joniturralde93 | Assigned To | => platform | ||
| 2018-06-26 16:59 | joniturralde93 | Modules | => Core | ||
| 2018-06-26 16:59 | joniturralde93 | Triggers an Emergency Pack | => No | ||
| 2018-07-06 11:55 | alostale | Status | new => acknowledged | ||
| 2018-07-06 11:55 | alostale | Type | defect => design defect | ||
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |