AEM Querybuilder search on the asset name | Community
Skip to main content
serenapitotti
Level 2
February 26, 2024
Solved

AEM Querybuilder search on the asset name

  • February 26, 2024
  • 1 reply
  • 1388 views

Hi there,

 

I need to perform a search through Querybuilder on AEM 6.5 leveraging on the asset name.
The search must be 

  • partial
  • case insensitive

I have already tried on the node name concatenating %25 at the beginning of my partial value searched and * at the end but it doesn't work.


Thank you,
Serena

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

@serenapitotti : For partial match, you can use 'like' operation. For eg:-

path=/content type=cq:Page 1_property=jcr:title 1_property.value=Fra% 1_property.operation=like

For case-insesntive, you can try with: 

property.operation=equalsIgnoreCase

For more info, you can refer this cheat-sheet: https://experienceleague.adobe.com/docs/experience-manager-65/assets/JCR_query_cheatsheet-v1.1.pdf?lang=en

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

thanks.

1 reply

Kamal_Kishor
Community Advisor
Kamal_KishorCommunity AdvisorAccepted solution
Community Advisor
February 26, 2024

@serenapitotti : For partial match, you can use 'like' operation. For eg:-

path=/content type=cq:Page 1_property=jcr:title 1_property.value=Fra% 1_property.operation=like

For case-insesntive, you can try with: 

property.operation=equalsIgnoreCase

For more info, you can refer this cheat-sheet: https://experienceleague.adobe.com/docs/experience-manager-65/assets/JCR_query_cheatsheet-v1.1.pdf?lang=en

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

thanks.

serenapitotti
Level 2
February 28, 2024

Unfortunately it's not working.

Kamal_Kishor
Community Advisor
Community Advisor
February 29, 2024

@serenapitotti : If you want to search using asset name, there is support to search using nodename. Please refer: https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md

nodenameThis is used to search exact nodenames for the result set. It allows few wildcards like: nodename=text, will search for any character or no character after text. nodename=text? will search for any character after text.

If this doesn't work, give me your query and exact use-case and I can try at my end to see what would work for that.
thanks.