How to pass Date Variable to DQL in DCTM-Reports
Options
I have added {audit}select event_name as Action,user_name as Performer, audited_obj_id as DocId, time_stamp as ActionDate from dm_audittrail where object_type='dm_document' and time_stamp <=Date(Today)and time_stamp >= Date('&fromdate','MM/dd/yyyy'); to tt_report DQL Query attribute in D2. But, it is not working for DCTM-Reports.
&fromdate is a Date variable from DCTM-Reports and which return value like 1/2/2020 7:05:02 PM
1
Comments
-
Just started to use Documentum Reports recently and am facing the same problem.
Am using
(a) Documentum Reports 20.4 (the menu File - About show its StimulSoft 2020.2.3) and
(b) D2 21.2
The syntax that work for me is dmi_workitem.r_creation_date >= DATE('&QueryStartDate')
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