Hibernate DetachedCriteria 一次排序多字段的结果集。。。。。

Question

select USERS.USERNAME,count(distinct(CHALLENGE.CHALLENGEID))as 'a1',
count(distinct(SOLUTION.SOLUTIONID)) as 'a2'
,count(distinct(IDEA.IDEAID)) as 'a3',
[color=red]count(distinct(CHALLENGE.CHALLENGEID))+
count(distinct(SOLUTION.SOLUTIONID))+
count(distinct(IDEA.IDEAID)) as 'a4'[/color]
from USERS left join CHALLENGE
on CHALLENGE.USERID=USERS.USERID left join SOLUTION
on SOLUTION.USERID=USERS.USERID left join IDEA
on IDEA.USERID=USERS.USERID
group by USERS.USERNAME
[color=red]order by a4 desc [/color]
--网上都是根据一个字段的排序
dc.addOrder(Order.desc(属性名));
有没有把记录多个字段结果统计起来，在案统计的条目在排序
例如：
public class User
{
....
int count1;
int count2;
int count3;
....
}
//把 count1+count2+count3的结果统计起来在排序 使用DetachedCriteria 语法。。。。

Answer 1

楼上说得对
[code="java"]
Projects.sqlProjection("子查询语句","myAlias", new Type[] { Hibernate.xxx});

dc.addOrder(Order.desc("myAlias"));
[/code]