Groups > comp.lang.java.programmer > #33844

JPQL: JOIN on the max value of a list

From	Cecil Westerhof <Cecil@decebal.nl>
Newsgroups	comp.lang.java.programmer
Subject	JPQL: JOIN on the max value of a list
Date	2016-02-17 04:51 +0100
Organization	Decebal Computing
Message-ID	<87twl8804j.fsf@Equus.decebal.nl> (permalink)

Show all headers | View raw

I am trying something in the lines of:
    SELECT inst
    FROM   instelling inst
    JOIN FETCH inst.aanvragen
    JOIN FETCH inst.aanvragen.beoordelingen

But the problem is that the field aanvragen is a list. So I get:
    JPQL does not allow traversal through multi-valued relation path.
    Try join instead.

I would like the JOIN to take place on the max value of aanvragen. Is
this possible? If so: how?

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof

Back to comp.lang.java.programmer | Previous | Next | Find similar | Unroll thread

Thread

JPQL: JOIN on the max value of a list Cecil Westerhof <Cecil@decebal.nl> - 2016-02-17 04:51 +0100

csiph-web