How can I count total issues on a project report? I see code for open issues but cannot figure out what it would be for all issues. | Community
Skip to main content
EliseCr
Level 2
Sep 3, 2020 2:30 PM UTC
Solved

How can I count total issues on a project report? I see code for open issues but cannot figure out what it would be for all issues.

I found count for open issues and tried different permutations in text mode with no success.

This is code for open issues:

valuefield=numberOpenOpTasks

querysort=numberOpenOpTasks

valueformat=int

displayname=

linkedname=direct

namekey=numberOpenOpTasks

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    SarahNaAccepted solution
    Level 6
    Sep 9, 2020 2:58 PM UTC

    Hi Elise -

    Try this:

    displayname=

    linkedname=direct

    namekey=totalOpTaskCount

    querysort=totalOpTaskCount

    valuefield=totalOpTaskCount

    valueformat=int

    View reply

    4 replies

    SarahNaAccepted solution
    Level 6
    Sep 9, 2020 2:58 PM UTC

    Hi Elise -

    Try this:

    displayname=

    linkedname=direct

    namekey=totalOpTaskCount

    querysort=totalOpTaskCount

    valuefield=totalOpTaskCount

    valueformat=int

    Translate
      EliseCrAuthor
      Level 2
      Sep 9, 2020 3:34 PM UTC

      @Sarah Nau‚ Thank you so much! This is exactly what I needed. I didn't realize I needed both total and count. I spent over a week trying to get the correct terminology from Workfront and still haven't received assistance so this is really helpful.

      Translate
      SarahNa
      Level 6
      Sep 9, 2020 3:39 PM UTC

      Happy to help!! 😊

      Translate
      CoreyAu1
      Level 2
      Sep 8, 2020 12:16 PM UTC

      The only workaround I've figured out is to group them. When you group things, the system tallies the grouped items together and puts a total in the bottom right corner. Not exactly what you're looking for, but maybe could work until you figure out the text mode.

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...