0034191: The sort on the hql widgets does not work when the hql query does not have a order by clause

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0034191	Openbravo ERP	A. Platform	public	2016-10-11 18:53	2022-02-01 08:05

Reporter	egoitz
Assigned To	Triage Platform Base
Priority	normal	Severity	minor	Reproducibility	always
Status	acknowledged	Resolution	open
Platform		OS	5	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	No

Summary	0034191: The sort on the hql widgets does not work when the hql query does not have a order by clause
Description	Sorting a grid by a column by clicking on the column header only works if the hql used to define the report contains an order by clause
Steps To Reproduce	-Access as system adminitrator -Go to the invoice to collect widget -Put the module as indevelopment and remove the order by clauase of the hql. -Save and Login with the Openbravo admin user -order by one column and then refresh the widget to ensure that the request is sent to the backend. NO items to show message appears and an error is raised on the backend becuase the query created has as order by no columns. "select columns* from tables where conditions order by;"
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2016-10-11 18:53	egoitz	New Issue
2016-10-11 18:53	egoitz	Assigned To	=> platform
2016-10-11 18:53	egoitz	Modules	=> Core
2016-10-11 18:53	egoitz	Triggers an Emergency Pack	=> No
2016-12-01 13:11	alostale	Status	new => acknowledged
2022-02-01 08:05	alostale	Assigned To	platform => Triage Platform Base

There are no notes attached to this issue.