My Oracle Support Banner

Order By Use In HQL Queries (Doc ID 2047800.1)

Last updated on AUGUST 04, 2022

Applies to:

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


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?


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

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