AEM 6.5.6 : Case Insensitive AEM Query Builder

[Annie_Rose_Peter]

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

[Ravi_Pampana · Accepted solution]

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.

[spidey1405]

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

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

[touseefk2181136]

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

Wildcard Case Insensitive Search using AEM Query Builder API