I have seen a couple posts here related to a similar issue, where JCR-SQL2 query returns 3 results in CRXDE Query Tool but 0 results in OSGI.  Here's my code:String query = "SELECT DISTINCT page.[jcr:path] FROM [cq:Page] AS page...";Session session = resourceResolver.adaptTo(Session.class);QueryMana...

I am trying to create a txt file under /conf but got this error:Exception occurred: This tree does not exist  Here is the simplified version of my code - ignoring the file content: Session session = resourceResolver.adaptTo(Session.class);Node confNode = session.getNode("/conf");Node fileNode = conf...

I am using JCR-SQL2 to query results in ACS commons. For search parameter, I am using ACS Commons Basic Parameter as well as Select Parameter. I would like to append one more result column with the search parameters. I was wondering what's the syntax to include that?    

This is very helpful! Thank you!

I would like to have a download button in the aem component console so that I can download it as an excel sheet. Here's the component console url: http://localhost:4502/libs/wcm/core/content/sites/components.html Is this possible? If so, is there any example on where to add the code? Thanks!

I have multiple queries in JCR-SQL2 and are currently separated in multiple ACS commons reports. This is not very user friendly as we need to go through different reports to look for the data. I was wondering if there's any way to merge these reports into one?