Hi All,
Has anyone dealt with timestamp ordering issue with multiple timestamps?
For instance, we have the following query:
/jcr:root/content/my-site//element(*,cq:PageContent)[@sling:resourceType='event-page' and (@datestamps >= '2018-05-01')] order by @datestamps descending
Supposed we have a few results returned and some of them have multiple entries for datestamps
event1 [2018-08-01],
event2 [2018-02-01, 2018-07-01, 2018-12-01] (repeating event)
event3[2018-06-01]
...
the results will be in the order of event1, event3, event2. As long as at least one of the datestamps is later than 2018-05-01, event2 will match, but then when dealing with sorting, XPath uses the oldest date/timestamp to sort. Is it possible to use the latest date to sort when dealing with descending?
Thanks,
-Kevin