DQL query which returns only year
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!
Comments
-
Thank you!
That works!
0 -
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.
0 -
@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
0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax