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.
