Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

queue topic report that references associated issues

Avatar

Level 2

I want to create a queue topic report that contains information about issues (requests) submitted under that queue topic. I can create an issue report that displays the associated queue topic, but I need the pivot of that.  Any ideas?

 

For background, I want to create a report that displays issues in 4 columns based on status - like a board view. I have created that report at the queue level (as a project report) so it contains all queue topics for that queue. Now I want to do something similar by queue topic. The catch is that this report has to be sendable in PDF format - which seems to eliminate  Boards.  This report (shown below) is basically a project report with 1 row - the queue project. I want to replicate this - if possible - with the 1 row being a queue topic.

VynetaRy_0-1728670516706.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 3

Hi @VynetaRy 

 

your options are limited: You can create an issue report where you group by queueTopic.

 

The UI of reports doesn't lend itself to a card view. 

 

By the way, if you print a Board to PDF - it'll capture 4 columns.

(Works only if you're not on Unified Experience)

You can create a bookmarklet that temporarily hides the visual noise to PDF-print the board:

  1. Create a board (Main Menu > Boards)
  2. Create a bookmark
  3. Edit the bookmark: 
    1. Name = Print Board
    2. URL = javascript
      followed by a colon, and then paste in the below

 

 

(() => { var printHeight = "2230px"; if(location.pathname.indexOf('/boards/')!=0){alert("This only works on Workfront Boards  ")}; var prevHeight = document.querySelector('div[data-testid="board-view"]').style.height;document.querySelector('div[data-testid="board-view"]').style.height = printHeight;document.querySelector('div[data-testid="board-view"]').style.overflow = "hidden visible";document.querySelector('div[data-testid="board-view"]').previousSibling.style.display="none";document.querySelector('div#navigation').style.display="none";document.querySelector('div[data-testid="board-view"]').parentNode.parentNode.previousSibling.firstChild.style.display = "none";document.querySelector('div[data-testid="header"]').firstChild.children[1].style.display="none";setTimeout(function () {window.print();document.querySelector('div[data-testid="board-view"]').style.height = prevHeight;document.querySelector('div[data-testid="board-view"]').style.overflow = "";document.querySelector('div[data-testid="board-view"]').previousSibling.style.display="";document.querySelector('div#navigation').style.display="";document.querySelector('div[data-testid="board-view"]').parentNode.parentNode.previousSibling.firstChild.style.display = "";document.querySelector('div[data-testid="header"]').firstChild.children[1].style.display="";}, 250); })()

 

 

 

 

Depending on the size of the columns you may need to set the "printHeight" - I just set it at a massive 2230px to get 3 pages. 

 

When you click this bookmark, it will hide unneeded elements, call up the print dialog, and then restore the UI. 

 

Example screenshot of print preview in Chrome:

print board.png