SQL Query in AEM

[umeshj24393]

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

[smacdonald2008]

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]

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