After giving JCR SQL2 in Author end it is getting this below error. If ACS common version 3.19.0  i used, then it is working fine and only the issue in 5.1.0. and 4.12.0.*ERROR* [10.2.6.53 [1639889901932] GET /var/acs-commons/reports/user-report/_jcr_content.results.html HTTP/1.1] org.apache.sling.e...

ACS common version is 5.1.0

Hi Arun,Thanks so much for replying for this issue and i am using this below query.SELECT * FROM [nt:base] as nodes WHERE ISDESCENDANTNODE('/home/users')AND nodes.[profile/lastLoggedIn] IS NOT NULLAND NOT ISDESCENDANTNODE([/home/users/community])AND NOT ISDESCENDANTNODE([/home/users/mac])AND NOT ISD...

Hi lukaszm /Arun,Thanks so much for replying for this issue and i am using this below query.SELECT * FROM [nt:base] as nodes WHERE ISDESCENDANTNODE('/home/users')AND nodes.[profile/lastLoggedIn] IS NOT NULLAND NOT ISDESCENDANTNODE([/home/users/community])AND NOT ISDESCENDANTNODE([/home/users/mac])AN...

Hi Team,Anybody please help on this below issue. if i execute the below query it is executing in CRX but in code level it is getting this below error. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) [org.apache.felix.http.jetty:4.1.4]at org.eclipse.jetty.server....