Expand my Community achievements bar.

Looking for a way to determine if an aggregate is being applied for a query

Avatar

Level 2

Hello,

I have to do queries that looks for child nodes in the following structure:

home/users/<app>/<user>/activity/likes/<year>/<month>/*

I've created the following aggregate to improve my queries performance:

<aggregate primaryType="rep:User">
<include>activity</include>
<include>activity/likes</include>
<include>activity/likes/*</include>
<include>activity/likes/*/*</include>
<include>activity/likes/*/*/*</include>
<include-property>activity/likes/*/*/*/resourcePath</include-property>
</aggregate>

Where "resourcePath" is the property I'll be filtering for.

Here is a sample query:

SELECT * FROM [nt:unstructured] AS node WHERE ISDESCENDANTNODE(node, [/home/users/<app>/<user>/activity/likes]) AND node.resourcePath IS NOT NULL

Now, I'm not sure whether it is being applied or not.

I tried following the instructions in this page:

http://helpx.adobe.com/experience-manager/kb/HowToDebugJCRQueries.html

But I wasn't able to get anything in connection with the aggregate.

So, I'm looking for a way to determine whether the aggregate is being applied or not.

Thanks in advance!

 

0 Replies