Report on projects with no tasks | Community
Skip to main content
MeganLe1
MeganLe1
Level 2
July 15, 2021
Solved

Report on projects with no tasks

  • July 15, 2021
  • 1 reply
  • 710 views

I have created a project report with a custom column to show the number of tasks for each project.

Text Mode for that column:

aggregator.displayformat=int

aggregator.function=MAX

aggregator.valuefield=project:totalTaskCount

aggregator.valueformat=intAsInt

displayname=# of Tasks

textmode=true

valuefield=project:totalTaskCount

valueformat=HTML

What I'm having a problem with, is setting up a filter for that column to only show me projects with 0 tasks. I'm sure I'm missing something super simple, but thought I'd ask for some help before I spend any more time on this.

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by MeganLe1

Of course I found my own answer right after I asked for help. If anyone else needs to know, this filter works to find projects without any tasks.

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:projectID=FIELD:ID

1 reply

MeganLe1
MeganLe1AuthorAccepted solution
Level 2
July 15, 2021

Of course I found my own answer right after I asked for help. If anyone else needs to know, this filter works to find projects without any tasks.

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:projectID=FIELD:ID

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe Employee
    July 16, 2021

    YES. I love that you found your own answer, but even more that you came back to share it with the community!! Thank you!!

      Terms & ConditionsAccessibility statement

      Loading footer...