should I post this "issue" in the jackrabbit newsgroup?
> -----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. > ____________________________________________________ >
