0 Replies Latest reply: Apr 18, 2012 10:42 PM by anuumar RSS

    Using JCR SQL2 query


      Hi All,


      I need a few examples of JCR SQL2 queries.


      In CQ 5.4, I need to programmatically:

      1. Fetch all the campaigns (inside path ‘/content/campaigns’)
      2. Fetch all the users and their permissions.
      3. Fetch all the pages/websites in CQ (inside path ‘/content’).
      4. Fetch what a teaser is composed of



      the teaser ‘myTeaser’ @ the path


      might return the child nodes at the paths: