AEM Query Builder | Community
Skip to main content
New Participant
May 6, 2024
Solved

AEM Query Builder

  • May 6, 2024
  • 4 replies
  • 757 views

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 ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

kautuk_sahni
Employee
May 16, 2024

@ayushag3 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
EstebanBustamante
New Participant
May 6, 2024

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-with-value-is-not-equal-to/td-p/573483 

 

Hope this helps.

Esteban Bustamante
sravs
sravsAccepted solution
New Participant
May 6, 2024