AEM Query Builder | Community
Skip to main content
A
AyushAg3
Level 2
May 6, 2024
Solved

AEM Query Builder

  • May 6, 2024
  • 4 replies
  • 772 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

sravs
Community Advisor
sravsCommunity AdvisorAccepted solution
Community Advisor
May 6, 2024

@ayushag3 ,you can find similar question https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/can-query-builder-search-on-multi-value-property-not-containing/m-p/264926

    EstebanBustamante
    Community Advisor and Adobe Champion
    EstebanBustamanteCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    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
      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      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
      Terms & ConditionsAccessibility statement

      Loading footer...