Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

shubhanshus3678
shubhanshus3678
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes

Likes
0

Posts

Posts
4

Discussions

Discussions
2

Questions

Questions
2

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by shubhanshus3678
Customize the badges you want to showcase on your profile
Re: QueryBuilder case insensitive like operation AEM 6.4
Avatar
Give Back
Level 1
shubhanshus3678
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
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

2.4K

Likes

0

Replies

0
QueryBuilder case insensitive like operation AEM 6.4
Avatar
Give Back
Level 1
shubhanshus3678
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
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

4.4K

Likes

0

Replies

5
Re: RangeIterator getSize() returns -1 for QueryResults getRows.getSize()
Avatar
Give Back
Level 1
shubhanshus3678
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
shubhanshus3678
- Adobe Experience Manager
Tried same implementation, getSize() is returning -1 when rows returned are more than 100

Views

2.5K

Likes

0

Replies

0
RangeIterator getSize() returns -1 for QueryResults getRows.getSize()
Avatar
Give Back
Level 1
shubhanshus3678
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
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.6K

Likes

0

Replies

3