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

Avatar

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

0 Replies

Avatar

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. 

Avatar

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