shubhanshus3678

Your achievements

0% to

Tip / to gain points, level up, and earn exciting badges like the new

shubhanshus3678

Offline

Joined the community 26-03-2019

Level 1

Job title here

Location here

Badges

Accepted Solutions

Likes

Posts

Discussions

Questions

Ideas

Blog Posts

Expand more

View leaderboards

Profile

Trophy case

Top badges earned by shubhanshus3678

Give Back

Ignite 1

Validate 1

Re: QueryBuilder case insensitive like operation AEM 6.4 - Adobe Experience Manager 01-04-2019

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.

2.7K

QueryBuilder case insensitive like operation AEM 6.4 - Adobe Experience Manager 26-03-2019

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

4.6K

Re: RangeIterator getSize() returns -1 for QueryResults getRows.getSize() - Adobe Experience Manager 26-03-2019

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

2.6K

RangeIterator getSize() returns -1 for QueryResults getRows.getSize() - Adobe Experience Manager 26-03-2019

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)

2.6K

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe