Unsolved
This post is more than 5 years old
4 Posts
0
3982
Need DQL query related to date
Hi,
Need DQL query to generate the list which contains files that are created in ECM on or before Jan 2010. Is there any DQL query that can be used. please to share?
dnvhariprasad
534 Posts
0
February 13th, 2013 09:00
you would get better visibility if you post in Documentum support forum instead of here.
for your requirement use the below dql:
select * from dm_document where r_creation_date > 'your date'
aldago-zF7Lc
463 Posts
0
February 14th, 2013 23:00
select r_object_id,r_creation_date from dm_sysobject where r_creation_date <= DATE('2010','yyyy')