Reporting and Analytics for Service

Get Involved. Join the Conversation.


    Ken Sands
    Is it possible to show the Report Definition as a report...
    Topic posted December 18, 2018 by Ken SandsRed Ribbon: 250+ Points 
    88 Views, 4 Comments
    Is it possible to show the Report Definition as a report column?
    Output the report definition as a column

    I have a report that shows information about reports, such as the Report ID (name), ACID, Owner, Last Run, etc.  

    Is there a table and column available that can show the report definition for each of these reports? 




    • Sebastiaan Draaisma

      Not the entire definition as this would contain info on filters, tables etc. But the basic info you are requesting should not be a problem. This can be retrieved from the analytics_core table

    • Ken Sands

      Thanks you for the information.   The data I am mostly seeking is the filter data (Name, Prompt, Expression, Operator, Value, Data Type )

    • Sebastiaan Draaisma

      Yeah, unfortunately, that is not available...
      You could place this as an idea in the lab.

      If you do, make sure to place a comment containing the link to your idea here as to increase exposure.
      I would vote for it.

      As for last run, this can be retrieved from the ac_audit_log table (see report id 13001 as an example)

    • Sebastiaan Draaisma

      I thought I will just update the topic.

      It is possible to read filters and variables and place this in a column. It is done through custom script with print_r($params,true)
      See attached report