Dashboards Report: list reports in dashboards? | Community
Skip to main content
laurence_jayawardane
laurence_jayawardane
Level 4
August 31, 2022
Solved

Dashboards Report: list reports in dashboards?

  • August 31, 2022
  • 2 replies
  • 1676 views

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

    Best answer by William--

    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



    2 replies

    GrahamJarrett
    GrahamJarrett
    Level 4
    August 31, 2022

    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

      William--
      Community Advisor
      William--Community AdvisorAccepted solution
      Community Advisor
      August 31, 2022

      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
        MoniqueEvans
        Community Advisor
        MoniqueEvansCommunity Advisor
        Community Advisor
        September 1, 2022

        I always forget about calendars! Thanks for sharing this @william-- 

        I'll add that you could use the basic share column code to combine these two lists into one report column.

         

        SHARING COLUMNS: Merge multiple columns into a single column.

        You can share the data from multiple columns to display it in one column, by adding a third column between them. The added middle column should have the following code in text mode:

        value=<br>
valueformat=HTML
width=1
sharecol=true

        You also have to add the following text to the left column:

        sharecol=true

        When sharing multiple columns (more than 2) start with the far right and work your way to the left

          laurence_jayawardane
          laurence_jayawardaneAuthor
          Level 4
          September 1, 2022

          @moniqueevans I was too afraid to break it (can list columns be appended together?! I guess they can!), so I tried on a copy and was very pleased to see this work. I now have a really meaningful report of all our dashboards... now if only we had "last viewed" for dashboards like we have for reports! I tried using the same text as would've been on the Reports reporting, to no avail... but you know what, I'm that much closer to what I wanted to do and it's great already!

          Terms & ConditionsAccessibility statement

          Loading footer...