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) 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 '...
I am getting -1 on executing getSize() method on rowIterator and
nodeIterator object from QueryResult getRows(). In doc it is suggested
to use RangeIterator.getNumberRemaining although no such method exists.
I want to get the total number of rows returned by the query. Any inputs
are helpful. RangeIterator (Content Repository for Java Technology API