I'm trying to put together a SQL2 query to find all of the rtePlugins under a cq:dialog node within a path.
Here is what I have so far:
select * from [nt:unstructured] as p where isdescendantnode (p, [/apps]) AND NAME(p)="rtePlugins"
But I'm missing the part where it needs to be under a cq:dialog
It should find these:
/apps/somename/components/page/main/page/cq:dialog/content/items/tabs/items/article/items/articleTitle/rtePlugins
But NOT find this
/apps/somename/components/page/main/page/dialog/content/items/tabs/items/article/items/articleTitle/rtePlugins
I've tried adding another isdescendantnode or contains ... but no luck so far.
Thank you in advance for any assistance.
-Dean