My Oracle Support Banner

Order By Use In HQL Queries (Doc ID 2047800.1)

Last updated on JUNE 04, 2024

Applies to:

Oracle Utilities Meter Data Management - Version 2.1.0.2 and later
Oracle Utilities Framework - Version 4.2.0.2.0 and later
Information in this document applies to any platform.

Goal

The following query:

 

returns this error:

"Order by name should be a result field or constant"

Adding an order by clause directly in the hql but causes this error

"HQL should not contain an order by-- use orderBy method calls"

What is the way to code an order by in the Oracle Utilities Application Framework?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.