[
https://issues.apache.org/jira/browse/JCR-2559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896582#action_12896582
]
Marian Simpetru commented on JCR-2559:
--------------------------------------
QueryManager qm = session.getWorkspace().getQueryManager();
String sql = "select * from [" + DL_FILE + "] where ISCHILDNODE([" + folderPath
+ "]) ";
Query q = qm.createQuery(sql, Query.JCR_SQL2);
QueryResult result = q.execute();
This sql also does not work when folderPath contains spaces (in version 2.1)
> JQOM DescendentNode Constraint Factory Method doesn't work with paths with
> spaces
> ---------------------------------------------------------------------------------
>
> Key: JCR-2559
> URL: https://issues.apache.org/jira/browse/JCR-2559
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: query
> Affects Versions: 2.0.0
> Reporter: chad davis
>
> The descendent node factory method doesn't work if the path of the node
> contains spaces, even those these are legal and work just fine in the
> session.getNode() node retrieval api. See my code snippets:
> NOTE: As per JCR-2558, the following code snippets use a slash at the end of
> the absolute path.
> DescendantNode constraint factory method doesn't work:
> qomFactory.descendantNode("mySelector","/documents/My Folder/" );
> However the following node retrieval works just fine:
> session.getNode("mySelector","/documents/My Folder/");
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
