<?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: what is the best way to recognize the dam asset expir... in Adobe Experience Manager Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370497#M18902</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15956069"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;&lt;P&gt;The property you are checking is of type &lt;EM&gt;"String"&lt;/EM&gt;. Can you change it as &lt;EM&gt;"Date"&lt;/EM&gt; type and check.&lt;/P&gt;</description>
    <pubDate>Tue, 14 Jul 2020 17:18:37 GMT</pubDate>
    <dc:creator>Vijayalakshmi_S</dc:creator>
    <dc:date>2020-07-14T17:18:37Z</dc:date>
    <item>
      <title>what is the best way  to recognize the dam asset expiration date im writing one scheduler with in query but i couldnt get the result.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370441#M18895</link>
      <description>&lt;P&gt;I gone through&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.adobe.com/content/help/en/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html#daterange" target="_blank"&gt;https://docs.adobe.com/content/help/en/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html#daterange&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;according to the url im using query as:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;queryMap.put("path", assetFolderPath);&lt;BR /&gt;queryMap.put("type", "dam:Asset");&lt;BR /&gt;queryMap.put("p.limit", "-1");&lt;BR /&gt;queryMap.put("daterange.property", "jcr:content/metadata/" + EXPIRATION_DATE);&lt;BR /&gt;queryMap.put("dterange.upperBound", dateFormat.format(calenderDate.getTime()));&lt;BR /&gt;queryMap.put("daterange,upperOperation", "&amp;lt;");&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can any one share me the best query to recognize my expire assets plzzzzzzzzzzzzzzzzzzz&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jul 2020 13:09:51 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370441#M18895</guid>
      <dc:creator>keshav_goud</dc:creator>
      <dc:date>2020-07-14T13:09:51Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370450#M18896</link>
      <description>&lt;P&gt;&lt;LI-USER uid="15956069"&gt;&lt;/LI-USER&gt;&amp;nbsp;Can you please confirm if you are trying to find the assets those are already expired or is going to expire in next couple of days? Are you tracking for any specific property?&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jul 2020 13:52:39 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370450#M18896</guid>
      <dc:creator>Asutosh_Jena_</dc:creator>
      <dc:date>2020-07-14T13:52:39Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370455#M18897</link>
      <description>&lt;P&gt;Use something like as below, here prism:expirationDate represents expiration date, and using properties lower bound and upper bound you can define the date range.&amp;nbsp;&lt;/P&gt;&lt;DIV class=""&gt;select&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;[jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr&lt;/DIV&gt;&lt;DIV class=""&gt;:content/metadata/prism:expirationDate] &amp;gt; cast('2017-03-22T07:00:00.000Z'&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;date) and [jcr:content/metadata/prism:expirationDate] &amp;lt; cast('2017-03-23T07:00:00.001Z'&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;as&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;date) and isdescendantnode(a,&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;'/content/dam')&lt;/DIV&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;</description>
      <pubDate>Tue, 14 Jul 2020 14:20:34 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370455#M18897</guid>
      <dc:creator>Nitin_laad</dc:creator>
      <dc:date>2020-07-14T14:20:34Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370456#M18898</link>
      <description>&lt;P&gt;You can possibly use a querry similar to:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;path=/content/dam&lt;BR /&gt;type=dam:Asset&lt;/P&gt;&lt;P&gt;group.1_daterange.property=jcr:content/metadata/@prism:expirationDate&lt;BR /&gt;group.1_daterange.upperBound=2020-07-14T23:59:59.000-04:00&lt;BR /&gt;group.1_daterange.lowerBound=2020-07-13T00:00:00.000-04:00&lt;BR /&gt;group.p.limit=-1&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jul 2020 14:21:32 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370456#M18898</guid>
      <dc:creator>berliant</dc:creator>
      <dc:date>2020-07-14T14:21:32Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370462#M18899</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15956069"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;&lt;P&gt;To find expired assets with respect to a specific date, query predicates you have used seems to be fine.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Given that you are not getting results, I suggest to execute first at &lt;EM&gt;querydebug.html(&lt;A href="http://localhost:4502/libs/cq/search/content/querydebug.html" target="_blank"&gt;http://localhost:4502/libs/cq/search/content/querydebug.html&lt;/A&gt;)&lt;/EM&gt; with hard coded date values targeting one or two sample assets.&lt;/P&gt;&lt;P&gt;Then when you see the results coming up, can write dynamically in code.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Screenshot below for reference:&lt;/STRONG&gt; Expired asset with respect to specific date in &lt;EM&gt;upperBound&lt;/EM&gt;.&lt;/P&gt;&lt;P&gt;On similar lines, based on your exact constraint on expired asset, can make use of related &lt;EM&gt;daterange&lt;/EM&gt; predicates to get desired results&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ExpiredAsset.png" style="width: 999px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/25446i986B74540C3A0271/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="ExpiredAsset.png" alt="ExpiredAsset.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jul 2020 14:44:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370462#M18899</guid>
      <dc:creator>Vijayalakshmi_S</dc:creator>
      <dc:date>2020-07-14T14:44:27Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370463#M18900</link>
      <description>hi @asuthoshj7327906</description>
      <pubDate>Tue, 14 Jul 2020 14:52:16 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370463#M18900</guid>
      <dc:creator>keshav_goud</dc:creator>
      <dc:date>2020-07-14T14:52:16Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370466#M18901</link>
      <description>&lt;P&gt;Hi &lt;A href="https://experienceleaguecommunities.adobe.com/t5/user/viewprofilepage/user-id/11077056" target="_blank"&gt;vijis31358935&lt;/A&gt;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;thanks for your comment , I'm trying the same as mention in the picture with this query but result not showing why?&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captudsfdfweere.PNG" style="width: 999px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/25447i845C03B0EF9DB657/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="Captudsfdfweere.PNG" alt="Captudsfdfweere.PNG" /&gt;&lt;/span&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Caperewwrewrerewerture.PNG" style="width: 975px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/25448iD9BB1D560DF9B783/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="Caperewwrewrerewerture.PNG" alt="Caperewwrewrerewerture.PNG" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jul 2020 15:13:48 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370466#M18901</guid>
      <dc:creator>keshav_goud</dc:creator>
      <dc:date>2020-07-14T15:13:48Z</dc:date>
    </item>
    <item>
      <title>Re: what is the best way to recognize the dam asset expir...</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370497#M18902</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15956069"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;&lt;P&gt;The property you are checking is of type &lt;EM&gt;"String"&lt;/EM&gt;. Can you change it as &lt;EM&gt;"Date"&lt;/EM&gt; type and check.&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jul 2020 17:18:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-the-best-way-to-recognize-the-dam-asset-expiration-date/m-p/370497#M18902</guid>
      <dc:creator>Vijayalakshmi_S</dc:creator>
      <dc:date>2020-07-14T17:18:37Z</dc:date>
    </item>
  </channel>
</rss>

