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

    Using JCR SQL2 query

    anuumar

      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

       

      (e.g.

      the teaser ‘myTeaser’ @ the path

      /content/campaigns/myCampaigns/myTeaser

      might return the child nodes at the paths:

      /content/campaigns/myCampaigns/myTeaser/jcr:content/par

      /content/campaigns/myCampaigns/myTeaser/jcr:content/par/image

      /content/campaigns/myCampaigns/myTeaser/jcr:content/par/flash

      /content/campaigns/myCampaigns/myTeaser/jcr:content/par/text

      /content/campaigns/myCampaigns/myTeaser/jcr:content/par/textimage

      )