Apr 29, 2024 · Solved: Hi Team, I am trying to write a JCR SQL2 query in AEM 6.5 to get the list of all pages of template - 669305

Apr 29, 2019 · In result i am able to getting 10 results with starting from offset. But if want actual full request set of the query Can you suggest me correct way to get it. I am trying to implement …

Solved: I'm running a query in the CQ5.5 query tool and trying to return a just 20 results. My query is like this: SELECT * FROM [nt:base] - 206601

Dec 12, 2022 · Issue with your SQL2 query is with comparing the dates a. [cq:lastModified] > a. [cq:lastReplicated]. I have executed rest of the query in my local and it's working fine.

Oct 13, 2021 · Hi, I would like to carry out search in AEM where in I would like to search for the exact word such as "Insurance Broker". The search should provide only that reference which has the exact …

Apr 20, 2022 · Solved: I’m trying to build a SQL2 Query where I want to search a String value within a multivalued property. e.g. something similar to this - 448805

Hi, Could you please let me know which is better to use performance wise: QueryBuilder APIs or SQL2? I understand QueryBuilder APIs internally converts to XPath queries, however would like to know …

Apr 29, 2024 · Hi , Count is not supported by JCR SQL2, so this will not work. I do not think you can achieve your goal using query only. Most likely you will need combine results from query with some …

Mar 2, 2025 · Need SQL2 Query for full text search .Do not want to use query builder.Please help me for the same.

Sep 26, 2018 · Is there a way to construct a SQL2 query that would find a multi-value property containing duplicate values? For instance, we have a multi-value String property called "language".