Hello!
Is it possible to get all the years during which the documents are created ?
Like for example:
select distinct year(r_creation_date) from dm_document;
I'm trying to generate a dropdown in D2 which list down all the years during which the documents were created in the repository.
I know this can be achieved by D2 dictionary but that needs to be managed, instead I was thinking if we can get years through DQL ?
Any ideas would be helpful!
