How to pass Date Variable to DQL in DCTM-Reports

Kishore_Nimmala
Kishore_Nimmala
edited February 20, 2020 in Documentum #1

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

Comments

  • DCTM_Guru
    DCTM_Guru
    edited February 20, 2020 #2

    Have you tried removing the single quotes around &fromdate in your query?

  • Phuah Mong Jen
    Phuah Mong Jen E
    #3

    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')

Categories