AutoSys Workload Automation

 View Only
  • 1.  Workload Automation DE Custom Report

    Posted Nov 12, 2018 11:39 AM

    I created a custom WA DE report in Desktop Client and I have some doubts about report filters.

    I used the CA WA Simple Listing with Date Filter Template and I´m using this query in my Data Set.

    select ESP_GENERIC_JOB.JOB_NAME,ESP_GENERIC_JOB.JOB_QUALIFIER,

    ESP_GENERIC_JOB.START_DATE_TIME,

    ESP_GENERIC_JOB.END_DATE_TIME,ESP_GENERIC_JOB.STATE,

    ESP_APPLICATION.APPL_NAME

    from ESP_GENERIC_JOB,ESP_APPLICATION

    where ESP_GENERIC_JOB.APPL_ID=ESP_APPLICATION.APPL_ID
    and ESP_GENERIC_JOB.START_DATE_TIME between ? and ?

    I used the date filters associated witn ESP_GENERIC_JOB.START_DATE_TIME but I can only use the filter in the Date format, not DateTime.

    I want to know how to configure it to use DateTime format and I want that when I run the report (or preview it) the date filter will be in calendar style, not forcing me to fill the date mannually



  • 2.  Re: Workload Automation DE Custom Report

    Broadcom Employee
    Posted Nov 14, 2018 05:46 AM

    Hi,

     

    The "Date Time" field will work even if you get a warning message. Please upload the report to the server and you can check in the "services" perspective.

     

    Thanks and regards,

    Ravi Kiran