Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Scott Heidenreich
    How to get list of reports with report IDsAnswered
    Topic posted September 12, 2019 by Scott HeidenreichBronze Trophy: 5,000+ Points 
    16 Views, 4 Comments
    Title:
    How to get list of reports with report IDs
    Summary:
    When I put the report ID into a report it shows the report name instead of the id
    Content:

    Hello,  I want to produce a list of reports in the system with their ac_id.  When I put the ac_id into analytics, I get the report name instead of the ID.  How do I see both the ac_id and the report name?

    Version:
    19B

    Best Comment

    Sristy Arya

    Hi Scott,

     

    Use analytics_core.ac_id.id to get the Report id.

     

    Thanks

    Sristy

    Comment

     

    • Sristy Arya

      Hi Scott,

       

      Use analytics_core.ac_id.id to get the Report id.

       

      Thanks

      Sristy

      • Scott Heidenreich

        Perfect and quick!  Thank you!  Is there documentation for these types of objects?  I didn't see this table in the list under analytics...

        • Sristy Arya

          Hi Scott,

           

          Glad it helped smiley.

          No idea whether there is any documentation for this , but one point you can keep in mind is wherever you have a table where you need to get the ids & is returning name just try using .id at the end.

          Example - Incident statuses table also inc_statuses.status_id gives name but to get id we use inc_statuses.status_id.id 

           

          Thanks

          Sristy