I have a JCR-SQL2 Query . And is being used by QueryManager to perform case insensitive search using lower() method. I want to do the same using QueryBuilder API. We are using aem 6.4 . and fn:lower-case(jcr:content/jcr:title) doesn't work.
SELECT * FROM[cq:Page] WHERE ISDESCENDANTNODE(path) AND
( lower([jcr:content/jcr:title]) LIKE '%vehi%' OR lower([jcr:content/jcr:title]) LIKE '%auto%' )
UNION
SELECT * FROM[cq:Page] WHERE ISDESCENDANTNODE(path) AND
( lower([jcr:content/jcr:description]) LIKE '%vehi%' OR lower([jcr:content/jcr:description]) LIKE '%auto%' )
UNION
SELECT * FROM[cq:Page] WHERE ISDESCENDANTNODE(path) AND
( lower([jcr:content/cq:tags]) LIKE '%vehi%' OR lower([jcr:content/cq:tags]) LIKE '%auto%' )
ORDER BY [jcr:content/cq:lastModified] desc
Any inputs are helpful
Solved! Go to Solution.
Views
Replies
Total Likes
The query builder does not support functions now and this solution stopped working after AEM 6.2. You need to write a custom predicate for this. Check this example - Experiencing Adobe Experience Manager - Day CQ: AEM 6 SP2 - Query Builder Predicate Evaluator for or...
Views
Replies
Total Likes
check AEM 6.2 "fn:lowercase" is not working
As Justin mentioned here, querybuilder search on Property case insensitive , QB would not be appropriate in this case
Views
Replies
Total Likes
For more info on QueryBuilder, see Scott's Digital Community: [Webinar | February ] Ask the AEM Community Expert: Best practice to quer...
Views
Replies
Total Likes
Created 2 queries , one with the method suggested and one without it.
In case of using fn-lowercase, even the XPath query is not translated. However without using method query returns result.
We are using AEM 6.4.
Views
Replies
Total Likes
The query builder does not support functions now and this solution stopped working after AEM 6.2. You need to write a custom predicate for this. Check this example - Experiencing Adobe Experience Manager - Day CQ: AEM 6 SP2 - Query Builder Predicate Evaluator for or...
Views
Replies
Total Likes
Very nice community response!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies