jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Hall <c...@hallwaytech.com>
Subject Re: SQL2 Help
Date Fri, 24 Sep 2010 21:43:36 GMT
For those not wanting to count out to the 110th character, it's the first
"n" of "nodeSet2" just inside of the ISDESCENDANTNODE function.


On Fri, Sep 24, 2010 at 5:01 PM, Carl Hall <carl@hallwaytech.com> wrote:

> I've been going in circles on this one.  Any help is greatly appreciated.
>
> I have a query (see below in message) that I can't quite figure out.  I
> want to return a parent node where any descendant node has a property ==
> 'tester'.  I don't understand why the following message is being returned.
>  As a side note, if 'AS' is written as 'as', the parser breaks.
>
> Lexical error at line 1, column 107.  Encountered: "n" (110), after : "("
> for statement: for $v in SELECT nodeSet1 FROM [nt:base] AS nodeSet1 INNER
> JOIN [nt:base] AS nodeSet2 ON ISDESCENDANTNODE(nodeSet2, nodeSet1) WHERE
> nodeSet1.[sling:resourceType] = 'sakai/user-home' and CONTAINS(nodeSet2.*,
> 'tester*') ORDER BY SCORE(nodeSet1) return $v
>

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