i have added a text file to my workspace and it contains the word "car"
with the sql search
SELECT * FROM nt:base WHERE contains(*, 'car')
a node will be found
the node path is /test.txt/jcr:content
But if i try to combine the full text search with a single property to limit the search result
it does not work
SELECT * FROM nt:base WHERE contains(*, 'car') and my:createuser = 'admin'
The node structure looks like
/test.txt (nt:file)
-my:createuser (Mixin)
- .. some properties
/jcr:content (nt:resource)
-jcr:mimetype
-jcr:lastModified
-jcr:data
-....
Is it possible to limit a full text search ?
thanks for help
claus
|