Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SQL Query in AEM

umeshj24393
Level 4
Level 4

HI,

In AEM 5.56 , i need to count the number of pages in /content/<folder-name>.

As there are three ways to execute it, Xpath,SQL,SQl2.

I am not able to generate query for it.

Any help

Thanks

2 Replies
smacdonald2008
Level 10
Level 10

See this thread - 

http://stackoverflow.com/questions/26400206/how-to-apply-aggregate-functionslike-min-max-count-in-jc...

So you want to do a query on the node type and specify the path. Then iterate the result set. 

Jitendra_S_Toma
Level 9
Level 9

Hi Umesh,

you question isn't clear to me. how are you trying to generate Query and what is the problem you are facing?

umeshj24393 wrote...

HI,

In AEM 5.56 , i need to count the number of pages in /content/<folder-name>.

As there are three ways to execute it, Xpath,SQL,SQl2.

I am not able to generate query for it.

Any help

Thanks