Skip navigation

CQ5

anuumar
anuumar Calculating status...
Currently Being Moderated

Using JCR SQL2 query

Apr 18, 2012 10:42 PM

Tags: #query #jcr #sql2

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

)

664 Views   0 Replies
 
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points