Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformminoralways2018-06-26 16:592018-07-06 11:55
Reporterjoniturralde93View Statuspublic 
Assigned Toplatform 
PriorityhighResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0038844: Aggregate functions as new columns cannot be filtered in grid (HQL based table)

DescriptionIf 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker