SQL2 Help

Avatar

Avatar

deana66659071

Avatar

deana66659071

deana66659071

26-10-2016

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

View Entire Topic

Avatar

Avatar

Anton_Smulskiy

Avatar

Anton_Smulskiy

Anton_Smulskiy

26-10-2016

Append your query with this:

AND [jcr:path] like '%/cq:dialog/%'