AEM Query Builder

[ayush_aem]

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 ?

[sravs · Accepted solution]

@ayush_aem ,you can find similar question https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/can-query-builder-search-o...

[EstebanBustamante]

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.

[HrishikeshKa]

Hi @ayush_aem ,

could you please refer below links

https://experienceleague.adobe.com/en/docs/experience-manager-65/content/implementing/developing/pla...

https://www.aemcq5tutorials.com/tutorials/aem-query-builder/

Reference: https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md

[kautuk_sahni]

@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.