Re: [xwiki-users] HQL order by object property

2014-08-28 Thread Sergiu Dumitriu
On 08/28/14 15:04, Danilo Oliveira wrote: > Hitchhiking on this thread... > Are there performance differences between the XWL and HQL? Depends. XWQL is just a meta-language, which gets translated to HQL, so the execution time of an XWQL query is the same as the equivalent HQL query. Two things cha

Re: [xwiki-users] HQL order by object property

2014-08-28 Thread Danilo Oliveira
Hitchhiking on this thread... Are there performance differences between the XWL and HQL? Thanks! 2014-08-28 4:49 GMT-03:00 vinc...@massol.net : > I’m curious, why don’t you use XWQL which we designed specifically to make > it easy to write such queries :) > > See http://extensions.xwiki.org/xwi

Re: [xwiki-users] HQL order by object property

2014-08-28 Thread vinc...@massol.net
I’m curious, why don’t you use XWQL which we designed specifically to make it easy to write such queries :) See http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module Thanks -Vincent  On 27 Aug 2014 at 21:54:05, Dale Davidson (ddavid...@ranchsystems.com(mailto:ddavid...@ranchsystems

Re: [xwiki-users] HQL order by object property

2014-08-27 Thread Dale Davidson
Thank you, Sergiu! Directly after I sent my post, it clicked in my head. I did indeed fail to perform the joins. What I have now is: #set($sql = ", BaseObject as obj, IntegerProperty as prop where obj.name = doc.fullName and obj.className = 'Sensor Types.SensorTypeClass' and obj.name <> 'Sensor

Re: [xwiki-users] HQL order by object property

2014-08-27 Thread Sergiu Dumitriu
On 08/27/2014 03:29 PM, Dale Davidson wrote: > Hello there, I've been banging my head against the desk a few days now > over this. I just can't find the answer online anywhere. > > I'd like to perform an HQL query and use a number property of an object on > each document to sort my results. I u

[xwiki-users] HQL order by object property

2014-08-27 Thread Dale Davidson
Hello there, I've been banging my head against the desk a few days now over this. I just can't find the answer online anywhere. I'd like to perform an HQL query and use a number property of an object on each document to sort my results. I understand SQL very well, but I just need to know the ob