<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: AEM 6.0 query issue on cq:tags in Adobe Experience Manager Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455451#M34005</link>
    <description>&lt;P&gt;Tags are the same on both author and publisher.&lt;/P&gt;</description>
    <pubDate>Thu, 09 Jun 2022 13:30:18 GMT</pubDate>
    <dc:creator>kevingtan</dc:creator>
    <dc:date>2022-06-09T13:30:18Z</dc:date>
    <item>
      <title>AEM 6.0 query issue on cq:tags</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455295#M34003</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We started seeing a weird issue about query optimization a few months ago. When we issue a query as:&lt;/P&gt;&lt;P&gt;&lt;FONT face="andale mono,times" size="2"&gt;/jcr:root/content/site//element(*,cq:PageContent)[@sling:resourceType='site/components/page/news-detail' and (@cq:tags = 'department:drama')] order by @date descending&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif" size="4"&gt;&lt;FONT size="3"&gt;We will see a warning message about traversing too many&lt;/FONT&gt;&amp;nbsp;&lt;FONT face="courier new,courier" size="3"&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;nodes,&amp;nbsp;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial,helvetica,sans-serif" size="4"&gt;&lt;FONT face="courier new,courier" size="3"&gt;org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 60000 nodes (212558 index entries) using index cq:tags with filter Filter&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There is a node "cqTags" under oak:index, as&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2022-06-08 at 2.54.51 PM.png" style="width: 641px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/41655iD030B4E6C67336F0/image-dimensions/641x143/is-moderation-mode/true?v=v2" width="641" height="143" role="button" title="Screen Shot 2022-06-08 at 2.54.51 PM.png" alt="Screen Shot 2022-06-08 at 2.54.51 PM.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The weird thing is that if we modify the query a bit,&amp;nbsp;&lt;FONT face="andale mono,times" size="2"&gt;/jcr:root/content/site//element(*,cq:PageContent)[@sling:resourceType='site/components/page/news-detail' and (@cq:tags = 'articles:drama')] order by @date descending. &lt;/FONT&gt;&lt;FONT face="andale mono,times" size="3"&gt;&lt;FONT face="arial,helvetica,sans-serif"&gt;Changing the tag value from "department:drama" to "articles:drama" will not issue any warning, given that both tags are valid in the /etc/tags. Also, the issue only takes place in the publisher, not the author.&amp;nbsp;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The "department:drama" tag property is as:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2022-06-08 at 2.54.12 PM.png" style="width: 589px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/41656i7A084EBEC93F2490/image-dimensions/589x135/is-moderation-mode/true?v=v2" width="589" height="135" role="button" title="Screen Shot 2022-06-08 at 2.54.12 PM.png" alt="Screen Shot 2022-06-08 at 2.54.12 PM.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Any idea where I should troubleshoot this?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;-k&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 08 Jun 2022 19:18:51 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455295#M34003</guid>
      <dc:creator>kevingtan</dc:creator>
      <dc:date>2022-06-08T19:18:51Z</dc:date>
    </item>
    <item>
      <title>Re: AEM 6.0 query issue on cq:tags</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455316#M34004</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="12225653"&gt;&lt;/LI-USER&gt;&amp;nbsp; - Have you verified if the tag 'articles:drama' is published and/or is available in the publisher?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 09 Jun 2022 00:35:53 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455316#M34004</guid>
      <dc:creator>Fanindra_Surat</dc:creator>
      <dc:date>2022-06-09T00:35:53Z</dc:date>
    </item>
    <item>
      <title>Re: AEM 6.0 query issue on cq:tags</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455451#M34005</link>
      <description>&lt;P&gt;Tags are the same on both author and publisher.&lt;/P&gt;</description>
      <pubDate>Thu, 09 Jun 2022 13:30:18 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-0-query-issue-on-cq-tags/m-p/455451#M34005</guid>
      <dc:creator>kevingtan</dc:creator>
      <dc:date>2022-06-09T13:30:18Z</dc:date>
    </item>
  </channel>
</rss>

