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...
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. Range...