Hi all, Im working on a Cuyahoga project and having some issues trying to write a complex hql query and was wondering if anyone could help. I have a domain that contains Nodes. Nodes have Sections which contain Articles. Nodes also have ChildNodes.
I'm trying to retrieve all Articles within a Node and any of its ChildNodes. The query looks like this: "from Article a where a.Section.Node in (select nod.ChildNodes from Node as nod where nod.Id = :nodeId)" but Im receiving the following error: [QueryException: unindexed collection before []...] I also tried: "from Article a where a.Section.Node.Id in (select nod.ChildNodes.Id from Node as nod where nod.Id = :nodeId)" which throws the following exception: expecting 'elements' or 'indices' after Id [] Adding elements doesnt help. Can anyone spot where I might be going wrong? Andy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
