<?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: how to get each dam asset size information with query... in Adobe Experience Manager Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383422#M12226</link>
    <description>Thank you so much, Manjunath</description>
    <pubDate>Thu, 15 Oct 2020 17:22:47 GMT</pubDate>
    <dc:creator>keehwan1</dc:creator>
    <dc:date>2020-10-15T17:22:47Z</dc:date>
    <item>
      <title>how to get each dam asset size information with query builder</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383396#M12224</link>
      <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;I am looking for query on how to select all dam assets(pdf, jpg and etc ) over 1 mega bites.&lt;/P&gt;&lt;P&gt;These are queries of what I can think of.&lt;/P&gt;&lt;P&gt;But when I checked&amp;nbsp; the results, they are not correct.&lt;/P&gt;&lt;P&gt;Could you please provide advice on how to get all dam assets bigger that 1 mega bites using query builder?&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Keehwan&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;lt;jpg&amp;gt;&lt;/P&gt;&lt;P&gt;type=dam:Asset&lt;BR /&gt;path=/content/dam&lt;BR /&gt;nodename=*.jpg&lt;/P&gt;&lt;P&gt;property=dam:size&lt;BR /&gt;lowerBound=1048576&lt;/P&gt;&lt;P&gt;p.limit=-1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;lt;pdf&amp;gt;&lt;/P&gt;&lt;P&gt;type=dam:Asset&lt;BR /&gt;path=/content/dam/gnb&lt;BR /&gt;nodename=*.pdf&lt;/P&gt;&lt;P&gt;property=dam:size&lt;BR /&gt;lowerBound=1048576&lt;/P&gt;&lt;P&gt;p.limit=-1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 15 Oct 2020 15:49:01 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383396#M12224</guid>
      <dc:creator>keehwan1</dc:creator>
      <dc:date>2020-10-15T15:49:01Z</dc:date>
    </item>
    <item>
      <title>Re: how to get each dam asset size information with query...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383417#M12225</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="1735723"&gt;&lt;/LI-USER&gt;&lt;/P&gt;&lt;P&gt;Please find below query to find all jpg images with more than 1MB size.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Query Builder console result :&lt;/STRONG&gt;&lt;STRONG&gt;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="querybuild-img.PNG" style="width: 999px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/27582iA0BA01BCEE3F9CFE/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="querybuild-img.PNG" alt="querybuild-img.PNG" /&gt;&lt;/span&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Query :&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;path=/content/dam&lt;BR /&gt;nodename=*.jpg&lt;BR /&gt;rangeproperty.property=@jcr:content/metadata/dam:size&lt;BR /&gt;rangeproperty.lowerBound=1048576&lt;BR /&gt;rangeproperty.lowerOperation=&amp;lt;&lt;BR /&gt;p.limit=-1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;1.4+ mb size image in DAM :&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image-crx.png" style="width: 762px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/27585iCEA3A8057ADE5E6C/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="image-crx.png" alt="image-crx.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;-Manjunath&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 15 Oct 2020 17:02:15 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383417#M12225</guid>
      <dc:creator>Manjunath_K</dc:creator>
      <dc:date>2020-10-15T17:02:15Z</dc:date>
    </item>
    <item>
      <title>Re: how to get each dam asset size information with query...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383422#M12226</link>
      <description>Thank you so much, Manjunath</description>
      <pubDate>Thu, 15 Oct 2020 17:22:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383422#M12226</guid>
      <dc:creator>keehwan1</dc:creator>
      <dc:date>2020-10-15T17:22:47Z</dc:date>
    </item>
    <item>
      <title>Re: how to get each dam asset size information with query...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383424#M12227</link>
      <description>&lt;LI-USER uid="1735723" login="keehwan1"&gt;&lt;/LI-USER&gt; You’re welcome &lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@31B4D6D7B3510763F3CBB2AAB7997408/emoticons/1f642.png" alt=":slightly_smiling_face:" title=":slightly_smiling_face:" /&gt;</description>
      <pubDate>Thu, 15 Oct 2020 17:34:28 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383424#M12227</guid>
      <dc:creator>Manjunath_K</dc:creator>
      <dc:date>2020-10-15T17:34:28Z</dc:date>
    </item>
    <item>
      <title>Re: how to get each dam asset size information with query...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383426#M12228</link>
      <description>&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="1735723"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Not sure about the use case for writing these queries but you can find those assets by using the OOTB Filter view under Assets. Here are the steps -&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;1) Navigate to&amp;nbsp;&lt;A href="http://localhost:4502/assets.html/content/dam" target="_blank" rel="noopener"&gt;http://localhost:4502/assets.html/content/dam&lt;/A&gt;&lt;/P&gt;&lt;P&gt;2) Switch to Filter view from the panel present on the top left.&lt;/P&gt;&lt;P&gt;3) This will allow you to select the path, file type, file size etc.&lt;/P&gt;&lt;P&gt;4) You can save your selected filter as a collection and then navigate to&amp;nbsp;&lt;A href="http://localhost:4502/mnt/overlay/dam/gui/content/collections.html/content/dam/collections" target="_blank" rel="noopener"&gt;http://localhost:4502/mnt/overlay/dam/gui/content/collections.html/content/dam/collections&lt;/A&gt;&amp;nbsp;if you would like to download all those images etc.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Narendra&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 15 Oct 2020 17:39:36 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-each-dam-asset-size-information-with-query-builder/m-p/383426#M12228</guid>
      <dc:creator>narendragandhi</dc:creator>
      <dc:date>2020-10-15T17:39:36Z</dc:date>
    </item>
  </channel>
</rss>

