jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benjamin Papez <jahia.pa...@gmail.com>
Subject SQL-2 Child Axis in order by clause
Date Wed, 21 Oct 2009 08:01:54 GMT

I am using Jackrabbit 2.0 alpha10 and I am testing the following SQL-2

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. Debugging the SimpleScoreDocComparator I see
that the values for comparing are null all the time. Looking at
*I assume that RelPathScoreDocComparator should be used instead. Does this
already work with SQL-2 queries or do I have to change the query in order to
make it work ?


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message