Hello Hugi;
You should be able to use EJBQL for this purpose as well. Here is a
(nicely re-formatted) example;
SELECT
DISTINCT ur.user.nickname
FROM
UserRating ur
WHERE
ur.user.active=true
AND ur.active=true
Have a go and see if it fits your needs.
As Andrus has pointed out, using EJBQL has the disadvantage that the
query is assembled as a string.
Regards;
On 31/10/14 10:58 pm, Hugi Thordarson wrote:
Once again, I’m looking into migrating to Cayenne from EOF :). One question
though: Our code depends heavily on raw row fetching (data rows) that traverses
relationships. I haven’t looked much at the Cayenne code, but do you believe
adding support for this to Cayenne would be a huge undertaking? Or does Cayenne
perhaps provide an alternative method to achieve the same results?
--
Andrew Lindesay
