How can I access joined part of Query ?

http://docs.jboss.org/hibernate/entitymanager/3.6/reference/en/html/querycriteria.html#querycriteria-from-join :



In documentation there is no code showing how to access address or country part of query,
I am able only to get persons, which are multiplied by joined relations, but I cannot access address and country.

Hi,
I haven't tried this but It should be something like:


or eventually you can select a particular field using:

By the way,
you should be able to find more example of the API in the JPA 2.1 specification, Chapter 6.4: http://download.oracle.com/otndocs/jcp/persistence-2_1-fr-eval-spec/index.html

Thx for Your reply,

Multiselect is ok, but I cannot tie it with join,

below query, without join is ok,

@Test
public void testMultiselect() {
System.out.println("testMultiselect start");
CriteriaBuilder builder = entityManager.getCriteriaBuilder();

CriteriaQuery<Tuple> criteria = builder.createTupleQuery();
Root<Order> orderRoot = criteria.from(Order.class);
Root<Item> itemRoot = criteria.from(Item.class);
criteria.where(builder.and(
builder.like(orderRoot.<String>get("customer"), "J%"),
builder.equal(orderRoot.get(Order_.id), itemRoot.get(Item_.order))));
criteria.multiselect(orderRoot, itemRoot);
TypedQuery<Tuple> typedQuery = entityManager.createQuery(criteria);

List<Tuple> result= typedQuery.getResultList();

for (Tuple tuple : result) {
System.out.println("---------");
Order order = (Order) tuple.get(0);
Item item = (Item) tuple.get(1);
System.out.println("tuple: " + " " + tuple );

System.out.println("Order: " + order.getCustomer());
System.out.println("Item: " + item.getProduct());

}

System.out.println("testMultiselect end " + result.size());
}

but If I try to add multiselect into it, I get additional cartesian product.

Possibly there is some possibility, to replace
Root<Item> itemRoot = criteria.from(Item.class);
with
Join<Order,Item> orderItems = orderRoot.join(Order_.items);