jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: SQL-2 Child Axis in order by clause
Date Mon, 26 Oct 2009 08:39:32 GMT
Hi,

On Wed, Oct 21, 2009 at 10:01, Benjamin Papez <jahia.papez@gmail.com> wrote:
> Hello,
>
> I am using Jackrabbit 2.0 alpha10 and I am testing the following SQL-2
> query:
>
> select press.* from [web_templates:pressContainer] as press inner join
> [jnt:translation] as translation on ischildnode(translation, press) where
> contains(press.*, '${searchTerm}') or contains(translation.*,
> '${searchTerm}') order by translation.[jcr:title_en] desc
>
> but the ordering does not work.

does it work without the join?

otherwise please file a jira issue and provide steps how to reproduce
the issue. thanks.

> Debugging the SimpleScoreDocComparator I see
> that the values for comparing are null all the time. Looking at
> *JCR-800<http://issues.apache.org/jira/browse/JCR-800>
> *I assume that RelPathScoreDocComparator should be used instead.

that one is only used when there is a relative path in the order by
clause with more than one segment. otherwise the
SimpleScoreDocComparator is used.

regards
 marcel

> Does this
> already work with SQL-2 queries or do I have to change the query in order to
> make it work ?
>
> Regards,
> Benjamin
>

Mime
View raw message