Unsolved
This post is more than 5 years old
4 Posts
0
4042
February 8th, 2013 18:00
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?
No Events found!
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')