OrderBy + sum() + BooleanExpression

Question

I've got two entities: Category and Product with one-to-many relation.

How can I order categories by number of their products, with price greater than 100? Something like (this doesn't work):

query.from(category).leftJoin(category.products,
    product).orderBy(product.price.gt(100).count().desc()).list(category)

Possibly related? Might help you. http://stackoverflow.com/questions/20090098/how-do-you-specify-multi-column-orderspecifier-for-use-in-springdata-and-queryds — Josef E., May 04 '15 at 17:59

score 2 · Accepted Answer · answered May 05 '15 at 01:35

Have you tried something like

query.from(category).leftJoin(category.products, product).where(product.price.gt(100)).
groupBy(category).orderBy(product.count().desc()).list(category);

I tried a variation of this on my current dataset and it produced reasonable results.

OrderBy + sum() + BooleanExpression

1 Answers1