CODEWITHSUNDEEP
javahibernatejpaspecifications
Alexey Savchuk
Alexey Savchuk

Reputation: 1138

How to order by fetch column?

How to order by fetch column?

My predicate:

CriteriaQuery<Connection> cquery = (CriteriaQuery<Connection>) query;
Fetch<Connection, ConnectionResearch> researches = root.fetch(Connection_.researches, JoinType.INNER);
cquery.orderBy(cb.asc( /* researches.get(ConnectionResearch_.pullforce) */ ));

How to set select query order by ConnectionResearch.pullforce fetch column?

Upvotes: 0

Views: 67

Answers (1)

Alexey Savchuk
Alexey Savchuk

Reputation: 1138

Solution:

Join<Connection, ConnectionResearch> researches = (Join<Connection, ConnectionResearch>) root.fetch(Connection_.researches);
cquery.orderBy(cb.asc(researches.get(ConnectionResearch_.pullForce)));

Upvotes: 1

Related Questions