Skip to main content
MoniqueEvans
New Participant
January 23, 2019
Question

Total Issue Count

  • January 23, 2019
  • 12 replies
  • 1766 views
I feel like I'm missing something obvious but is there a way to have a count of the total number of issues on a project? I can only seem to pull the number of open issues. I wanted to create a report that pulls any projects with > 8k issues as a warning to admins that we need to make a new queue since the max is 10k. Any suggestions? Monique Evans Stanley Black & Decker, Inc.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

12 replies

Level 8
January 24, 2019
Hey Monique, Based on our API explorer, you can call to "totalOpTaskCount" as a column in a project report. It's not available via the GUI, but it's super simple to set up. Here's the code for it: displayname=Number of Total Requests linkedname=direct namekey=totalOpTaskCount querysort=totalOpTaskCount textmode=true valuefield=totalOpTaskCount valueformat=int And here's what I did to get it: I added the Number of Open Issues column, switched to text mode, changed numberOpenOpTasks to totalOpTaskCount then I set the displayname= and saved it. I hope this helps! Thanks! Dustin Martin Assigned Support Engineer Workfront
Level 10
January 23, 2019
well, this isn't a great suggestion, but at the very least, you can create an issue report, group by project name, download the summary view to excel, turn on excel's filter function and select in the Count column for any value over 8000. if you are set up to use queue topics in workfront, you can specifically filter first for issues that have queue topics, so you don't get every single issue. If you had a specific way of identifying your queues, this would help as well. e.g. We have a project status called "Request queue" so I could run an issue report looking for issues in projects that have a request queue status. All depends on what you want to filter out. The generic report (pulling all issues) was fine for me, even though I got 33000 rows, because I was able to employ filters in excel to weed it down to 4. -skye