Jan 18, 2022 · Hi, I wanna get the assets(i.e. using sql2) which is recently uploaded on dam.

Jan 12, 2024 · Good morning, I have a problem related to the query. I have two environments, one local and one production with the same "content" and "applications". When I run the …

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 …

Jan 10, 2023 · Getting group members via SQL2 query won't be possible because it doesn't store the actual path of members. Instead it does store as WeakReference []. As you can see, …

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

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 …

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 …

Jun 30, 2022 · Another option you have is to query the data using JCR-SQL2. Place the result set into a Java collection and then order the collection with your own app logic.

Oct 19, 2016 · Solved: I'm using AEM 6.2. Is it possible to update content using a SQL2 query with the Tools, Query, SQL2 tool? Example Select select * - 241439

Jul 18, 2023 · HI, Within a Model associated with a Component a JCR_SQL2 Query is performed with the method resolver.findResources(query, Query.JCR_SQL2); Is there a way to cache the …