java - Hibernate 更改 @Formula 中的别名

Question

我有一个字段:

@Formula(value = "(select max(crm_kk_rejestr.data_otrzymania) " +
                   "from crm_kk_rejestr " + 
                   "where crm_kk_rejestr.idkntrh = idkntrh)")
private Date dataOtrzymania;

我想按此字段排序，但出现错误:

ORDER BY column or expression must be in SELECT list in this context.

Answer 1

有一个解决方案(SQL Server)，例如:

private String yourFieldForAlias;

@Formula("( validSQLquery ) as 'yourOwnAlias', NULL")
public String getYourFieldForAlias() {
  return yourFieldForAlias;
}

生成的查询将是:

....
 ( validSQLquery ) as 'yourOwnAlias', null as formula0_0_
....

你只需要:

order by yourOwnAlias

hibernate annotation formula custom alias