Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

AEM 6.5.6 : Case Insensitive AEM Query Builder

Avatar

Avatar
Applaud 5
Level 1
Annie_Rose_Peter
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
Give Back
Ignite 1
View profile

Avatar
Applaud 5
Level 1
Annie_Rose_Peter
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
Give Back
Ignite 1
View profile
Annie_Rose_Peter
Level 1

19-05-2021

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

 

AEM 6.5.6 Case Insensitive querybuilder

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
Ravi_Pampana
MVP

Likes

190 likes

Total Posts

239 posts

Correct Reply

74 solutions
Top badges earned
Establish
Contributor
Shape 1
Ignite 5
Ignite 3
View profile

Avatar
Establish
MVP
Ravi_Pampana
MVP

Likes

190 likes

Total Posts

239 posts

Correct Reply

74 solutions
Top badges earned
Establish
Contributor
Shape 1
Ignite 5
Ignite 3
View profile
Ravi_Pampana
MVP

19-05-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.

Answers (0)