P Marksson wrote:This query throws an exception with no details.
Which exception do you get?
Could you try the simplest version of that query using nested properties?
If that doesn't work try something similar based on the group id
Hope it works!
Kind regards,
Roel
PS. It might be worth mentioning that
Group might be interpreted as a HQL keyword as it is part of the
GROUP BY clause. If it's an issue, try enclosing
Group within square brackets (
[Group]), single or double quotes.