Dashboards Report: list reports in dashboards? | Community
Skip to main content
laurence_jayawardane
laurence_jayawardane
Level 4
Aug 31, 2022 12:49 AM UTC
Solved

Dashboards Report: list reports in dashboards?

Hi Workfront community!

 

I'm building a report that lists all our Dashboards, and I just wanted to list which Reports are on them for each row in the table. Is that even possible? I tried finding something that might sound like a collection of Reports in the API Explorer, but I don't see anything that seems to be it. Do you either 1) know what text mode to use to list reports on dashboard, or 2) how do you go about keeping track of what's in your Dashboards for instance cleanup?

 

Thanks  😀,

Laurence

    William--
    William--Accepted solution
    New Participant
    Aug 31, 2022 3:25 PM UTC

    Hi Laurence, 

    In a dashboard report, the below textmode in a view column will display the reports contained in each dashboard: 

    displayname=Reports
listdelimiter=<br>
listmethod=nested(portalTabSections).lists
textmode=true
type=iterate
valueexpression={internalSection}.{name}
valueformat=HTML

     

     To show which calendars are contained in a dashboard, a separate column is necessary: 

    displayname=Calendars listdelimiter=<br> listmethod=nested(portalTabSections).lists textmode=true type=iterate valueexpression={calendarPortalSection} valueformat=HTML



    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    View reply

    8 replies

    William--
    William--Accepted solution
    New Participant
    Aug 31, 2022 3:25 PM UTC

    Hi Laurence, 

    In a dashboard report, the below textmode in a view column will display the reports contained in each dashboard: 

    displayname=Reports
listdelimiter=<br>
listmethod=nested(portalTabSections).lists
textmode=true
type=iterate
valueexpression={internalSection}.{name}
valueformat=HTML

     

     To show which calendars are contained in a dashboard, a separate column is necessary: 

    displayname=Calendars listdelimiter=<br> listmethod=nested(portalTabSections).lists textmode=true type=iterate valueexpression={calendarPortalSection} valueformat=HTML



    Translate
    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
      laurence_jayawardane
      laurence_jayawardaneAuthor
      Level 4
      Sep 1, 2022 1:13 AM UTC

      This is exactly what I was looking for @william--, thank you! 

      Translate
      GrahamJarrett
      GrahamJarrett
      Level 4
      Aug 31, 2022 3:22 PM UTC

      You can sort of do this the other way around... 

      If you create a report of Reports, you can add a column for what Dashboards a particular report is on. Its a collections column. The script for the column is:

       

      link.linkproperty.0.name=ID
      link.linkproperty.0.valuefield=ID
      link.linkproperty.0.valueformat=val
      link.lookup=link.view
      link.value=val(objCode)
      listdelimiter=<hr>
      listmethod=nested(portalTabSections).lists
      name=Dashboards
      stretch=0
      textmode=true
      type=iterate
      valuefield=portalTab:name
      valueformat=HTML
      width=300

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...