[xwiki-users] using subqueries in HQL

2010-05-18 Thread Colesnicov Eugen
Hello everybody! I need some help about construction of a subquery. I have 2 classes: projects and steps. Also, name of a projectclass pages - is one of a property of a class step (for this reason, If I know project, I can find all steps of this project). I have one query: #set ($hql = ,

Re: [xwiki-users] using subqueries in HQL

2010-05-18 Thread Marius Dumitru Florea
Hi Eugen, Looks like you are looking for an HQL query that returns a map of (project - list of steps) pairs which is not possible. The result set is a flat structure. At most you can get a list of [project, step] arrays: [p1, s1] [p1, s2] ... [p2, s1] ... Why do you need to list all the

Re: [xwiki-users] using subqueries in HQL

2010-05-18 Thread Marius Dumitru Florea
and btw http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HStatistics leads to some HQL examples with sub queries, using the protected search API though. Marius On 05/18/2010 05:10 PM, Marius Dumitru Florea wrote: Hi Eugen, Looks like you are looking for an HQL query