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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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.
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.
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?
I have written blog on this topic if could help the people facing this issue
Wildcard Case Insensitive Search using AEM Query Builder API