Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

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

    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? 

    Version:
    18B

    Comment

     

    • 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

      analytics_core.ac_id.id
      analytics_core.ac_id
      analytics_core.owner_acct_id

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