sorry for re-activating this thread again. I just noticed that adding "order by [jcr:score]" only works, ie delivers the hit count, when there is no WHERE-clause. E.g.: select * from [nt:unstructured] order by [jcr:score] returns the hit count (query.execute().getRows().getSize()), whereas select * from [nt:unstructured] where entity = "customer" order by [jcr:score] doesn't. Bug, feature, (jackrabbit-)limitation?
> -----Original Message----- > From: Greg Klebus [mailto:[email protected]] > Sent: Tuesday, August 24, 2010 4:26 PM > To: [email protected] > Subject: Re: JCR-SQL2 : paging > > > On Tue, Aug 24, 2010 at 3:55 PM, Clemens Wyss > <[email protected]> wrote: > > @Mark: could you link me to the mentioned thread? > > Not sure about the thread. This is, however, a Jackrabbit FAQ [1]. You > can use "order by jcr:score" if you don't have more specific ordering > needs. > > [1] > http://jackrabbit.apache.org/frequently-asked-questions.html#F requentlyAskedQuestions-Whyisthesizeofmyqueryresult1%3F HTH Greg -- Greg Klebus Sr. Product Manager mailto: [email protected] T +41 61 226 9898 F +41 61 226 9897 Info-World 2009 Technology of the Year Award: Best Web CMS http://www.infoworld.com/slideshow/2009/01/194-2009_technology-4.html Day Software AG Barfuesserplatz 6, 4001 Basel, Switzerland web: http://www.day.com/ twitter: @gklebus @daysoftware ____________________________________________________ This message is a private communication. If you are not the intended recipient, please do not read, copy or use it, and do not disclose to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. The sender does not assume any liability for timely, trouble-free, complete, virus free, secure, error free or uninterrupted arrival of this email. For verification please request a hard-copy version. ____________________________________________________
