Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

AEM Query Builder

Avatar

Level 2

Hi All,

 

In AEM there is a multivalued property jcr:mixinTypes. Its one of the properties are granite:AuthenticationRequired. Using AEM Query Builder I am trying to get all the nodes which does not have granite:AuthenticationRequired as one of the property of jcr:mixinTypes.

I have tried this approach but it does not work. 
group.1_group.2_property=@jcr:mixinTypes
group.1_group.2_property.value=granite:AuthenticationRequired
group.1_group.2_property.operation=not

 

Can anybody help me rectify the query ?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
4 Replies

Avatar

Correct answer by
Community Advisor

Avatar

Community Advisor

Hi, 

I don't know if you can achieve that using queryBuilder, but you can do it using JCR-SQL2.  You can find an example here: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-query-to-fetch-pages-w... 

 

Hope this helps.



Esteban Bustamante

Avatar

Administrator

@ayush_aem Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community. 



Kautuk Sahni