<?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: Fetch Content from AEM between two dates using Query in Adobe Experience Manager Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440767#M125820</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17408763"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;Could you check&amp;nbsp;&lt;A href="https://hashimkhan.in/aem-adobecq5-code-templates/query-builder/" target="_blank" rel="noopener"&gt;https://hashimkhan.in/aem-adobecq5-code-templates/query-builder/&lt;/A&gt;&amp;nbsp;. You have pretty much everything you are looking for in here. Even though the blog is pretty old, all the content is valid unless there is any deprecated API , which is not there for query builder AFAIK&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;daterange :&amp;nbsp;&lt;/STRONG&gt;This predicate is used to search a date property range.&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.property :&amp;nbsp;&lt;/STRONG&gt;Specify a property which is searched.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.lowerBound :&amp;nbsp;&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Fix a lower bound eg.&amp;nbsp;2010-07-25&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.lowerOperation :&amp;nbsp;&lt;/STRONG&gt;“&amp;gt;” (default) or “&amp;gt;=”&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.upperBound:&amp;nbsp;&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Fix a lower bound eg. 2013-07-26&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.upperOperation:&lt;/STRONG&gt;&amp;nbsp;“&amp;lt;” (default) or “&amp;lt;=”&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Some more useful links :-&amp;nbsp;&lt;A href="http://www.adobe.com.by/pdf/meetup-3/QueryBuilder_and_Custom_Predicates.pdf" target="_blank"&gt;http://www.adobe.com.by/pdf/meetup-3/QueryBuilder_and_Custom_Predicates.pdf&lt;/A&gt;&lt;BR /&gt;(&amp;nbsp;&lt;EM&gt;&lt;STRONG&gt;Check page 11 for your requirement)&lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Veena&lt;/P&gt;</description>
    <pubDate>Mon, 14 Feb 2022 05:32:37 GMT</pubDate>
    <dc:creator>Veena_Vikram</dc:creator>
    <dc:date>2022-02-14T05:32:37Z</dc:date>
    <item>
      <title>Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440624#M125770</link>
      <description>&lt;P&gt;Hi Community,&lt;/P&gt;&lt;P&gt;I want to fetch content from AEM between two particular dates by writing a query.&lt;/P&gt;&lt;P&gt;Can i get the help, what query should i exactly write to get this problem solved?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;</description>
      <pubDate>Fri, 11 Feb 2022 11:22:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440624#M125770</guid>
      <dc:creator>Arindam15</dc:creator>
      <dc:date>2022-02-11T11:22:43Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440628#M125772</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17408763"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;You can make use of daterange to write a query, a sample query looks like:&lt;/P&gt;&lt;PRE&gt;path=/content
daterange.property=cq:lastModified
daterange.lowerBound=2020-05-08T23:59:59
daterange.upperBound=2021-01-31T00:00:00&lt;/PRE&gt;&lt;P&gt;This will fetch all the content exisiting on path :/content from 08 may 2020 to 31 jan 2021&lt;BR /&gt;&lt;BR /&gt;Please also refer references:&lt;BR /&gt;&lt;A href="https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-query-date-range-property-to-query/td-p/378971" target="_blank"&gt;https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-query-date-range-property-to-query/td-p/378971&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en#relativedaterange" target="_blank"&gt;https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en#relativedaterange&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-the-nodes-from-jcr-after-specified-date/m-p/228355" target="_blank"&gt;https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-get-the-nodes-from-jcr-after-specified-date/m-p/228355&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 11 Feb 2022 12:15:35 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440628#M125772</guid>
      <dc:creator>milind_bachani</dc:creator>
      <dc:date>2022-02-11T12:15:35Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440630#M125773</link>
      <description>&lt;P&gt;Here is an example to find content between two dates&lt;/P&gt;&lt;P&gt;SELECT * FROM [nt:unstructured] AS s WHERE&lt;BR /&gt;path=/content/campaigns/&lt;BR /&gt;type=nt:unstructured&lt;BR /&gt;property=sling:resourceType&lt;BR /&gt;property.value=cq/personalization/components/campaignpage&lt;BR /&gt;1_daterange.property=jcr:created&lt;BR /&gt;1_daterange.upperBound=10111573478358&lt;BR /&gt;1_daterange.upperOperation=&amp;lt;=&lt;BR /&gt;2_daterange.property=jcr:created&lt;BR /&gt;2_daterange.lowerBound=1793478378&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Result would be&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrijeshYadav_0-1644581802900.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/38487i5663DCAC9104E676/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="BrijeshYadav_0-1644581802900.png" alt="BrijeshYadav_0-1644581802900.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 11 Feb 2022 12:17:11 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440630#M125773</guid>
      <dc:creator>BrijeshYadav</dc:creator>
      <dc:date>2022-02-11T12:17:11Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440731#M125806</link>
      <description>&lt;P&gt;Let me show you what i did:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;path=/content/retailBank&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;type=cq:page&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;relativedaterange.property=jcr:lastModified &lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;relativedaterange.lowerBound=2021-01-18 &lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;relativedaterange.upperBound=2022-01-19&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here i am getting results, but the results stays same even if i change the dates, which means the dates are not working, even if i give lowerBound as 2019-01-01, the results are not changing. i have added time to the dates, then also same.&lt;/P&gt;&lt;P&gt;Please help&lt;/P&gt;</description>
      <pubDate>Sun, 13 Feb 2022 07:27:22 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440731#M125806</guid>
      <dc:creator>Arindam15</dc:creator>
      <dc:date>2022-02-13T07:27:22Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440732#M125807</link>
      <description>&lt;P&gt;Can you please explen me this line:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;1_daterange.upperBound=10111573478358&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;what is this number specify?? How would i change this number based on my conditions?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Similary for the lowerBound dates i need help to understand the number pattern.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thanks&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 13 Feb 2022 07:32:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440732#M125807</guid>
      <dc:creator>Arindam15</dc:creator>
      <dc:date>2022-02-13T07:32:00Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440767#M125820</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17408763"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;Could you check&amp;nbsp;&lt;A href="https://hashimkhan.in/aem-adobecq5-code-templates/query-builder/" target="_blank" rel="noopener"&gt;https://hashimkhan.in/aem-adobecq5-code-templates/query-builder/&lt;/A&gt;&amp;nbsp;. You have pretty much everything you are looking for in here. Even though the blog is pretty old, all the content is valid unless there is any deprecated API , which is not there for query builder AFAIK&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;daterange :&amp;nbsp;&lt;/STRONG&gt;This predicate is used to search a date property range.&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.property :&amp;nbsp;&lt;/STRONG&gt;Specify a property which is searched.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.lowerBound :&amp;nbsp;&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Fix a lower bound eg.&amp;nbsp;2010-07-25&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.lowerOperation :&amp;nbsp;&lt;/STRONG&gt;“&amp;gt;” (default) or “&amp;gt;=”&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.upperBound:&amp;nbsp;&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Fix a lower bound eg. 2013-07-26&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;daterange.upperOperation:&lt;/STRONG&gt;&amp;nbsp;“&amp;lt;” (default) or “&amp;lt;=”&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Some more useful links :-&amp;nbsp;&lt;A href="http://www.adobe.com.by/pdf/meetup-3/QueryBuilder_and_Custom_Predicates.pdf" target="_blank"&gt;http://www.adobe.com.by/pdf/meetup-3/QueryBuilder_and_Custom_Predicates.pdf&lt;/A&gt;&lt;BR /&gt;(&amp;nbsp;&lt;EM&gt;&lt;STRONG&gt;Check page 11 for your requirement)&lt;/STRONG&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Veena&lt;/P&gt;</description>
      <pubDate>Mon, 14 Feb 2022 05:32:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440767#M125820</guid>
      <dc:creator>Veena_Vikram</dc:creator>
      <dc:date>2022-02-14T05:32:37Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440801#M125839</link>
      <description>&lt;P&gt;&amp;nbsp;&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="DEBAL_DAS_0-1644832171147.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/38508iFAC2916BC47E9AD7/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="DEBAL_DAS_0-1644832171147.png" alt="DEBAL_DAS_0-1644832171147.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Here you could see I am getting 361 pages.&lt;/P&gt;&lt;P&gt;Now I have changed the upperbound date and getting different count(results) -&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DEBAL_DAS_1-1644832305672.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/38509i5B8E43A789AC685D/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="DEBAL_DAS_1-1644832305672.png" alt="DEBAL_DAS_1-1644832305672.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Could you please review.&lt;/P&gt;</description>
      <pubDate>Mon, 14 Feb 2022 09:52:46 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440801#M125839</guid>
      <dc:creator>DEBAL_DAS</dc:creator>
      <dc:date>2022-02-14T09:52:46Z</dc:date>
    </item>
    <item>
      <title>Re: Fetch Content from AEM between two dates using Query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440815#M125845</link>
      <description>&lt;P&gt;Let's suppose you want to retrieve list of pages based between current time and 14 days based on some criteria then you could refer below example -&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;map.put("path", pagepath.trim());&lt;BR /&gt;map.put("type", FMConstants.CQ_PAGE_NODETYPE);&lt;/P&gt;&lt;P&gt;map.put("1_group.daterange.property", "jcr:content/expires");&lt;BR /&gt;map.put("1_group.daterange.lowerBound", getCurrentDate());&lt;BR /&gt;map.put("2_group.relativedaterange.property", "jcr:content/expires");&lt;BR /&gt;map.put("2_group.relativedaterange.upperBound", "14d");&lt;BR /&gt;map.put("p.limit", "-1");&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please keep this also&lt;/P&gt;</description>
      <pubDate>Wed, 16 Feb 2022 12:32:47 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fetch-content-from-aem-between-two-dates-using-query/m-p/440815#M125845</guid>
      <dc:creator>DEBAL_DAS</dc:creator>
      <dc:date>2022-02-16T12:32:47Z</dc:date>
    </item>
  </channel>
</rss>

