Order By Use In HQL Queries

(Doc ID 2047800.1)

Last updated on OCTOBER 19, 2016

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?


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms