Highlighted

AEM tags :: SQL Querying

Avatar

Avatar

Murali89

Avatar

Murali89

Murali89

04-06-2018

We have a multi level Tag Hierarchy i.e Brand>Location>Shop-ID>Terminal-ID .

A terminal or shopid can belong to multiple locations and brands. i,e UK>London>Shop-1>terminal-1234, UK>Paris>Shop-1>terminal-1234 , UK>XYZ>Shop-2>terminal-1234.

All the pages will be tagged to a location i.e London,Paris etc and not to terminal-ID or Shop-Id. We have third parties querying AEM with terminal ID or Shop ID and we need to return all pages that is being tagged to any parent tag which has terminal-Id below it in tag hierarchy.

What is the best possible approach to tackle this use case?

Replies

Highlighted

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

04-06-2018