Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

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 ?

4 Replies

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