Order by year instead of date

Experience Manager (PaaS/OnPrem)
1

Hi,

Is it possible to just order by year instead of the whole date.

Currently I am using

.orderBy("hippostdpubwf:publicationDate").descending();

Thanks,
RK

2

see date resolution part:

3

This seems to be the date range queries but how to sort the results just by year instead of the complete date?
For example, if the publish date in the articles is 2019-05-06 then sort by just YYYY in that field.
The reason is, I want my articles to be sorted based on year and title. I don’t want them to be sorted based on the complete date and title.

4

Can you try this?

import org.hippoecm.repository.util.DateTools;
import org.hippoecm.repository.util.DateTools.Resolution;

//...
.orderByDescending(DateTools.getPropertyForResolution("hippostdpubwf:publicationDate", Resolution.YEAR));
5

That worked. Thanks a ton!