Thanks Davide,
But it turns out that the contains() does not work, (using \"\" seems to
work fine instead of using []).
So this works:
statement = "select * from [nt:unstructured] as theNode where
ISDESCENDANTNODE('/searchpath') and myproperty like '%teststring%'"
This does not:
statement = "select * from [nt:unstructured] as theNode where
ISDESCENDANTNODE('/searchpath') and contains(theNode.*,'teststring')";
My goal is to search for any node under a certain path, and on any property
containing a string.., "myproperty like '%X%' " is cumbersome to use.
Am I using "contains" improperly?
Adrien
On Wed, Oct 22, 2014 at 1:17 AM, Davide Giannella <[email protected]> wrote:
> On 21/10/2014 22:08, Adrien Lamoureux wrote:
> > ...
> > String statement = "select * from \"nt:unstructured\" as theNode where
> > ISDESCENDANTNODE('/searchpath') and contains(theNode.*,'teststring')";
> > ...
> Shouldn't it be
>
> SELECT * FROM [nt:unstructured] AS theNode
> WHERE ISDESCENDANTNODE('...')
> AND CONTAINS(...)
>
> notice the '[]' rather than the '"'.
>
> D.
>
>
>
