AEM 6.2 Predicate fn:lowercase generate special characters | Community
Skip to main content
Unnikrishnankv
Unnikrishnankv
Level 3
December 30, 2016
Solved

AEM 6.2 Predicate fn:lowercase generate special characters

  • December 30, 2016
  • 3 replies
  • 1553 views

 final Predicate authorNamePredicate = new Predicate("@authorName", "property");
            authorNamePredicate.set(JcrPropertyPredicateEvaluator.OPERATION, JcrPropertyPredicateEvaluator.OP_LIKE);
            authorNamePredicate.set(QueryUtils.PROPERTY, "@fn:lower-case("+CharacterConstants.SLASH +JcrConstants.JCR_CONTENT + CharacterConstants.SLASH + "authorName)");
            authorNamePredicate.set(QueryUtils.VALUE, authorName.toLowerCase());
            group.add(authorNamePredicate);

This is the code used to generate xpath query that is added below

=/jcr:root/content/geo//*[@jcr:primaryType = 'cq:Page' and not(jcr:content/@hideInNav) and jcr:content/@jcr:title != 'Master Article' and jcr:like(fn:lower-case_x0028_/jcr:content/@authorName_x0029_, 'soumik dey')]/rep:excerpt(.) order by jcr:content/@cq:lastModified descending

special characters generating area are highlighted in bold. Could you please help me to sort out this.

Thanks!,

Devakrishna 

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 kautuk_sahni

Hi 

Please have a look at this forum thread:-

Link:- http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manager.topic.html/forum__scgy-we_r_runningaquery.html

//  we never officially supported functions.  Hence not a bug. You have to file enhancement request to support xpath function. it is a known problem with the OAK repository

Please create a day care ticket for this.

 

Reference post telling about toupper/toLower in AEM :- http://www.wemblog.com/2013/04/how-to-create-custom-query-predicate-in.html

// You need to create a create custom query predicate.

I hope this would help you.

~kautuk

3 replies

smacdonald2008
smacdonald2008
Level 10
December 30, 2016

What version of AEM are you using? 

Unnikrishnankv
UnnikrishnankvAuthor
Level 3
January 2, 2017

AEM 6.2

kautuk_sahni
Community Manager
kautuk_sahniCommunity ManagerAccepted solution
Community Manager
January 3, 2017

Hi 

Please have a look at this forum thread:-

Link:- http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manager.topic.html/forum__scgy-we_r_runningaquery.html

//  we never officially supported functions.  Hence not a bug. You have to file enhancement request to support xpath function. it is a known problem with the OAK repository

Please create a day care ticket for this.

 

Reference post telling about toupper/toLower in AEM :- http://www.wemblog.com/2013/04/how-to-create-custom-query-predicate-in.html

// You need to create a create custom query predicate.

I hope this would help you.

~kautuk

Kautuk Sahni
Terms & ConditionsAccessibility statement

Loading footer...