Total Issue Count

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

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

And I didn't think about it until after I submitted this response, but you can also use a filter, but it again has to be done in text mode. Fairly simple though: numberOpenOpTasks=80 numberOpenOpTasks_Mod=gte Thanks! Dustin Martin Assigned Support Engineer Workfront

Hi Monique, And if, following on Dustin's excellent suggestion, you are looking to filter on the total number of Issues, rather than just the Open issues (with "OpTask" being the term Workfront uses for "Issues", under the hood), I expect you could use a filter such as this: totalOpTaskCount=8000 totalOpTaskCount_Mod=gte ...to look for those Projects approaching the 10K limit you seek to avoid. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Thank you all so much for the great suggestions!!! Dustin's report column is exactly what I am looking for. I completely forgot about the API Explorer. *Doh* Ideally, I wanted a report rather than a filter, so that I can set it to send to me quarterly so I can quickly check on any queues getting close to the Workfront limit, instead of having to remember myself. This will work perfectly until Workfront changes the maximum number of Issues limits! Monique Evans Stanley Black & Decker, Inc.

I'd like to count the number of issues related to a task, to display in a report of tasks. How can I do that? Akimi Larson

Hi Akimi, You can use the code I suggested above for the number of issues as a collection on a task report. It'll show the number of issues on a task. You also can't add a summary to a collections field (at least, I've never figured it out.) I hope that helps! Dustin Martin Assigned Support Engineer Workfront

Thanks for the reply. Do you mean this code? It does not work for me. The column is blank, even though I know that this task in this row resolves 4 issues. displayname=Number of Total Requests linkedname=direct namekey=totalOpTaskCount querysort=totalOpTaskCount textmode=true valuefield=totalOpTaskCount valueformat=int FYI, I am using the following code in the column before, and the names of the four issues do indeed show up in this column for this row. displayname=Resolvables listdelimiter= listmethod=nested(resolvables).lists textmode=true type=iterate valuefield=name valueformat=HTML Akimi Larson

Akimi, I think the ""https://wf-pro.com/textmode/text-mode-views-collections/#issues-resolved">Issues Resolved " text mode will give you what you need on a task report. The example says it's for a project report, but it should work in a task or issue report as well. Thanks, Narayan

Thanks Narayan! Akimi, Issues Resolved are for any issues that tie their resolution to that task. The totalOpTaskCount will only list the issues on that task. (An issue can 'live' on a task or project.) Hope this helps! Thanks, Dustin Martin Assigned Support Engineer Workfront