Is it possible to select node ancestors by SQL2 query?
For example
I have: /content/categories/sport/football node
Want to select: /content, /content/categories, /content/categories/sport nodes
JCR: Get all ancestors of current node
484 Views Asked by Normal At
1
There are 1 best solutions below
Related Questions in JCR
- Sling 7 JCR SQL Query Fails On Unicode-Value Properties
- Adobe CQ: Copy node from one CQ instance to another using crx/de
- Sling Mock is not allowing to get ResourceResolverFactory
- Javax JCR Node getProperties and Titles
- Apache sling : org.apache.sling.api.resource.PersistenceException: Unable to create node at /var/discovery))
- How to programatically delete revisions of a page in CQ5?
- JCR vs JPA for a DMS: performance, benefits, drawbacks
- AccessDeniedException when writing into JCR (JackRabbit) [Magnolia]
- How does Jackrabbit generate jcr:uuid (in AEM)?
- CQ - Check whether the resource object is valid
- How to query jackrabbit jcr to get nodes ordered by number of matches (using SQL2/XPATH)?
- Temporary files are not getting deleted in Apache Jackrabbit
- Recursive search in JCR repo via java
- How to stop filevault to compress jcr hierarchy?
- How to Query Jackrabbit for same name siblings
Related Questions in JCR-SQL2
- Identical Xpath query to a sql2 query?
- How to query jackrabbit jcr to get nodes ordered by number of matches (using SQL2/XPATH)?
- Recursive search in JCR repo via java
- How to Query Jackrabbit for same name siblings
- Index and full-text-search with Jackrabbit, Lucene using Tika
- Querying case-insensitive paths with SQL2 ISDESCENDANTNODE in CQ5
- Jackrabbit - Select node with maximum property value
- Node Identifier of copied node in Jackrabbit not found while deleting
- How do I do a multi-level properties query in JCR 2.0 SQL2?
- Need Jackrabbit sql 2 equivalent query for xpath query
- How to escape dynamically generated String values in a JCR SQL2 query?
- AEM/CQ: UI for one-off JCR-SQL / SQL2 / XPath queries with tabular output?
- JCR: Get all ancestors of current node
- JCR SQL2 Multivalue properties search
- how to get substring in JCR:SQL2?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You can, but assuming you have other siblings at those levels it's not very easy or dynamic. Honestly, it'll probably be far easier and far more performant to just use the
Nodemethods to walk up the ancestors. Remember that you can get theNodeobject(s) for each row in a JCR-SQL2 query result.Alternatively, if you just want the paths to the ancestors, then you can implicitly get these from the path of a result node (e.g.,
/content/categories/sport nodes).