Expand my Community achievements bar.

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