Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Report on projects with no tasks

Avatar

Level 2

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 2

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

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

Avatar

Administrator

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