DQL query which returns only year

imranganath · January 9, 2019

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!

DCTM_Guru · January 9, 2019

Try this:

select distinct(DATETOSTRING("r_creation_date",'yyyy')) from dm_document

imranganath · January 9, 2019

Thank you!

That works!

PanfilovAB · January 9, 2019

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 ?

Don't do that - it has poor performance.

DCTM_Guru · January 9, 2019

PanfilovAB - I thought DQL in data dictionary could be cached (at least at base CS level, not sure about D2 dictionary).

imranganath · January 10, 2019

@PanfilovAB - If the result of the query is limited to small result set, I think there will no be such performance issues ?

@DCTM_Guru - Yes, D2 also has an option for caching

Comments