Query for AEM Tags along with property search in bulk set of nodes

[archana_r]

Hi All, 

I have a requirement to query for matching tags on parent node and matching property on child nodes.  we need to query each time, based on the user selection.  As this a bulk query, can we create an index that fit both my searches?  Or is there a better way to restructure content to optimize query?

[Sudheer_Sundalam · Accepted solution]

@archana_r ,

You may write both SQL2 or XPath query to find the matching nodes based on the tags.

If we know the more details on the query requirement, we maybe able suggest on how to approach the query.

After you figure out the query, you can use this Oak Index generator tools to create indexes to improve query performance

https://oakutils.appspot.com/generate/index