JAVA Hibernate alias ordering problem

Today, when doing statistical functions, this problem is encountered, because the query results are statistical data, that is, the use of the sum method generated by the field,

SelectRefdate,sum(Triggercount) asTriggercount,sum( Case  whenUnique_key is NULL  Then 0 ElseTrigger_countEnd) asHitCount fromTriggerstatisticwhere User=:User  andType=: type andRefdate>=: FromDate andRefdate<=: ToDateGroup  byRefdateOrder  byHitCountASC

Will prompt that triggerstatistic does not exist HitCount property

Then use the column ordinal of the query to sort

The columns of the query have

1:refdate

2:triggercount

3:hitcount

To sort hitcount This column as long as you use ORDER by 3 Asc/desc

Then instead:

SelectRefdate asRefdate,sum(Triggercount) asTriggercount,sum( Case  whenUnique_key is NULL  Then 0 ElseTrigger_countEnd) asHitCount fromTriggerstatisticwhere User=:User  andType=: type andRefdate>=: FromDate andRefdate<=: ToDateGroup  byRefdateOrder  by 3 ASC

JAVA Hibernate alias ordering problem