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.

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) AN...