Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
Date: Wed, 28 Mar 2012 22:46:05 +1000
Message-ID: 
 <CAJw7DjD1NWPMk9qXzJy8wcPFCnwLQmDDYuXkLn8X3KD9JKguMw@mail.gmail.com>
Subject: jcr:contains query issues
From: Torgeir Veimo <torgeir@netenviron.com>
To: users@jackrabbit.apache.org
Content-Type: text/plain; charset=ISO-8859-1

I'm trying to query (using xpath xyntax) for a number of nodes with
sorting based on how many tags on each node matches a set of tags.

I'm currently trying to do this using

//element(*, nt:base)[jcr:contains(@tagproperty, 'tag1 tag2 tag3')]
order by @jcr:score

but it doesn't work very well. Instead I can use

//element(*, nt:base)[jcr:contains(@tagproperty, 'tag1') or
jcr:contains(@tagproperty, 'tag2') or jcr:contains(@tagproperty,
'tag3')] order by @jcr:score

but the query string can potentially become very large.

Additionally, I'm also trying to include nodes that doesn't match any
of the tags, but just sort them such that they end up below the
matching nodes. This requires an additional 'dummy match', but I'm
having trouble letting this dummy match have a lower boost than the
jcr:contains, even when I boost the contains, (all nodes have a name
property):

//element(*, nt:base)[(jcr:contains(@tagproperty, 'tag1^10') or
jcr:contains(@tagproperty, 'tag^10') or jcr:contains(@tagproperty,
'tag3^10') or @name)] order by @jcr:score

Is there a better way of doing this?

-- 
-Tor