jpa-2.0 - Mysema QueryDSL JPAQuery for SQL groupby 子句和 order by

Question

我有 Items 类:

@Entity
@Table(name ="Items")
Class Items{
    @ID
    private long id;
    private String upc;
    private long itemNo;
    private int qty;
   -----
}

我需要从 QueryDSL 的 JPAQuery 生成以下 sql 语句。

select itemNo, upc, count(*) t from Items group by ITEM_NO, UPC order by t;

QueryDSL 示例需要修改 order by 子句:

QItems items = QItems.items;
query.from(items)
.groupBy(items.itemNo,items.upc)
.orderby(<Dont Know How to sort on count>).list(items.itemNo,items.upc,items.count());

需要帮助来正确起草此查询吗？

Answer 1

这应该有效

NumberPath<Long> count = Expressions.numberPath(Long.class, "c");
QItems items = QItems.items;
query.from(items)
    .groupBy(items.itemNo,items.upc)
    .orderby(count.asc())
    .list(items.itemNo,items.upc,items.count().as(count));