since ‎26-03-2019
‎10-12-2019
shubhanshus3678
Level 1
Re: QueryBuilder case insensitive like operation AEM 6.4
Avatar

shubhanshus3678

shubhanshus3678
- Adobe Experience Manager
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

1.8K

Likes

0

Replies

0
QueryBuilder case insensitive like operation AEM 6.4
Avatar

shubhanshus3678

shubhanshus3678
- Adobe Experience Manager
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 '...

Views

3.7K

Likes

0

Replies

5
Re: RangeIterator getSize() returns -1 for QueryResults getRows.getSize()
Avatar

shubhanshus3678

shubhanshus3678
- Adobe Experience Manager
Tried same implementation, getSize() is returning -1 when rows returned are more than 100

Views

2.4K

Likes

0

Replies

0
RangeIterator getSize() returns -1 for QueryResults getRows.getSize()
Avatar

shubhanshus3678

shubhanshus3678
- Adobe Experience Manager
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 Version 2.0)

Views

2.5K

Likes

0

Replies

3