Order By Use In HQL Queries (Doc ID 2047800.1)

Last updated on OCTOBER 19, 2016

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

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