AEM 6.5.6 : Case Insensitive AEM Query Builder | Community
Skip to main content
Level 2
May 19, 2021
Solved

AEM 6.5.6 : Case Insensitive AEM Query Builder

  • May 19, 2021
  • 2 replies
  • 3095 views

How to make query builder case-insensitive , using fn:lower-case is not working as desired. Please find the below query how to make it case-insensitive?(searching the we-retail tag section for Apparel tag). 

path=/content/cq:tags/we-retail
p.limit=-1
property.value=%app%
property=jcr:title
p.hits=full
type=cq:Tag
property.operation=like

 

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 Ravi_Pampana

Hi,

 

Take a look at https://blogs.perficient.com/2020/11/11/case-insensitive-queries-with-the-aem-query-builder/ We need to add custom predicate to achieve the requirement.

2 replies

Ravi_Pampana
Community Advisor
Ravi_PampanaCommunity AdvisorAccepted solution
Community Advisor
May 19, 2021

Hi,

 

Take a look at https://blogs.perficient.com/2020/11/11/case-insensitive-queries-with-the-aem-query-builder/ We need to add custom predicate to achieve the requirement.

Level 4
September 23, 2022

Hey @ravi_pampana I want to perform case insensetive query in a group like this: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/case-insensetive-properties-aem-6-5-query-builder-api/m-p/547939#M136192

 

Can you help me understand how can I use the custom predicate that you showed? Additionally, where is it supposed to be added?

touseefk2181136
Level 3
September 2, 2024

I have written blog on this topic if could help the people facing this issue

Wildcard Case Insensitive Search using AEM Query Builder API