Robuta

https://sql2.ru/ SQL2.ru - Главная страница ru https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/need-sql2-query-for-aem-6-2-228043 Need SQL2 query for AEM 6.2 | Community Hi,Please help me in writing SQL2 query to search for all the pages containing custom component property.I have custom "bodycopy" component which has a... needqueryaemcommunity https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/how-to-find-whether-particular-image-rendition-exists-or-not-using-query-debugger-or-sql2-query-38531 How to find whether particular image rendition exists or not using query debugger or SQL2 query? |... Hi All,I want to search for image nodes which don't have particular image rendition.For example.,Suppose I have a path as '/content/dam/mycompany/catalo... how to find https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/sql2-query-with-contains-does-not-find-any-nodes-27224 SQl2 query with contains does not find any nodes | Community Hello,I'm facing following strange situation and I have no idea about this behavior, using AEM6.4. Given is following situation: In my project exis... does notquerycontainsfindnodes https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/convert-xpath-query-into-sql2-query-23292 convert xpath query into SQL2 query | Community i need to convert below xpath query type=cq:PageContentpath=/content/enproperty=xxx/sling:resourceTypeproperty.value=xx/headerdateCompariso... convertxpathquerycommunity https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/how-to-find-particular-image-log-exists-on-what-pages-using-sql2-query-221628 How to find particular image log exists on what pages using SQL2 query? | Community I have a requirement where I need a list of pages, just to know that a particular image logo exists on what pages. As highlighted in the following... how to find https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/sql2-query-to-list-all-users-in-a-group-23573 SQL2 query to list all users in a group | Community How to get the list of all users in a group using SQL2 query? I tried this: select * from [rep:User] as user inner join [rep:Group] as group on user.[jc... list all usersquerygroupcommunity https://experienceleaguecommunities.adobe.com/adobe-experience-manager-sites-8/how-do-i-limit-the-number-of-results-from-a-sql2-query-15003 How do I limit the number of results from a SQL2 query? | Community 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] AS s WHERE ISDESCENDANT... how do i