Asset expiry schedular AEM | Community
Skip to main content
S
Adobe Employee
SateeshRe2Adobe Employee
Adobe Employee
April 2, 2024
Solved

Asset expiry schedular AEM

  • April 2, 2024
  • 3 replies
  • 722 views

Hi Team,

 

I am using Asset Expire Scheduler to send out the notifications for the up loaders when any asset is set to expire.

I did try to debug the query is something like this 

03.04.2024 01:35:13.524 *DEBUG* [8.29.230.18 [1712079313521] GET /libs/cq/search/content/querydebug.html HTTP/1.1] com.day.cq.search.impl.builder.QueryImpl xpath query: /jcr:root/content/dam//element(*, dam:Asset)[((jcr:content/metadata/@prism:expirationDate >= xs:dateTime('2024-04-03T17:10:00.000.000Z') and jcr:content/metadata/@prism:expirationDate <= xs:dateTime('2024-04-03T17:20:00.000.000Z')))]

when I execute the same in the query builder it is not returning the results . and when I use the below, it works 

 

path =/content/dam
type = dam:Asset
daterange.property = jcr:content/metadata/@prism:expirationDate
daterange.lowerBound = 2024-04-03T17:10:00+5:30
daterange.upperBound = 2024-04-03T17:20:00+5:30
daterange.lowerOperation >=
daterange.upperOperation <=

 

Now, my question is what makes the difference in +5:30 and .000Z, How to overcome this ? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Harwinder-singh

@sateeshre2  Check in which date format these dates are getting saved as properties in JCR. is it UTC format or is it a timezone offset format.

+5:30 is a time zone offset that is added when someone updated these date properties from India (as India is 5 hours 30 minutes ahead of GMT ). 

3 replies

Harwinder-singh
Community Advisor
Harwinder-singhCommunity AdvisorAccepted solution
Community Advisor
April 2, 2024

@sateeshre2  Check in which date format these dates are getting saved as properties in JCR. is it UTC format or is it a timezone offset format.

+5:30 is a time zone offset that is added when someone updated these date properties from India (as India is 5 hours 30 minutes ahead of GMT ). 

    arunpatidar
    Community Advisor
    arunpatidarCommunity Advisor
    Community Advisor
    April 8, 2024

    Hi @sateeshre2 

    Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

    Arun Patidar
      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      May 17, 2024

      @sateeshre2  Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...