jackrabbit-oak-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jukka Zitting <jukka.zitt...@gmail.com>
Subject Re: Converting XPath to SQL-2
Date Tue, 03 Apr 2012 12:18:08 GMT
Hi,

On Tue, Apr 3, 2012 at 2:09 PM, Thomas Mueller <mueller@adobe.com> wrote:
>    /jcr:root/content//*[@test='hello']

I think that should be:

    select * from [nt:base] where [test]='hello'
        and (isdescendantnode('/content') or issamenode('/content'))

Or alternatively we come up with an extra constraint:

    select * from [nt:base] where [test]='hello'
        and isdescendantorsamenode('/content')

BR,

Jukka Zitting

Mime
View raw message