jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hsp" <piccina...@ibest.com.br>
Subject Searching with like over the path
Date Mon, 26 Jun 2006 20:54:55 GMT
Hi;
 I am doing a search in sql with the following:

"SELECT * FROM my:base WHERE jcr:path LIKE '/Folder1/%' " +
"  AND NOT jcr:path LIKE '/Folder1/%/%' "
And the result will be only the nodes under the Folder1 but not their subnodes, OK, it works.

But if I put the following:
"SELECT * FROM my:base WHERE jcr:path LIKE '/Folder1/F%' "
I want the nodes under Folder1 and begining the name with F, but there is no results. Why,
is this an issue or it is out of the spec of jcr?
Is there another way to get the nodes in such situation?

Thanks
Helio.





Mime
View raw message