Need a DQL to get the count of docs create by a certain user in the last week. This is what I have so far:
select count (*) from dm_document where scan_location_cd='USER'and r_creation_date >=date(yesterday)
You will get a faster response if move this discussion to the Documentum Developer Community.
Please Read - DO NOT POST TECHNICAL QUESTIONS TO THE DOCUMENTUM CONNECT FORUM!
With this query, you count the number of document created by USER between now and yesterday. You can now adjust the time slot !
Moving this discussion to the Documentum Developer Community.
select count (*) from dm_document where scan_location_cd='USER'and datediff(day,r_creation_date,date(today))<=7
