Hi, On 30.09.2010 09:45, Clemens Wyss wrote: > should I post this "issue" in the jackrabbit newsgroup?
This would probably make sense ... Regards Fleix > >> -----Original Message----- >> From: Clemens Wyss [mailto:[email protected]] >> Sent: Wednesday, September 29, 2010 11:27 AM >> To: '[email protected]' >> Subject: RE: JCR-SQL2 : paging >> >> >> 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. >> ____________________________________________________ >> >
