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:
But NOT find this
I've tried adding another isdescendantnode or contains ... but no luck so far.
Thank you in advance for any assistance.
Append your query with this:
AND [jcr:path] like '%/cq:dialog/%'