AnsweredAssumed Answered

Is there a way to use Power Filter to filter on a COUNT of a certain subobject type?

Question asked by REliTownsend on Sep 24, 2015
Latest reply on Jun 7, 2016 by Janet Ulrich

Hi all,

 

Hopefully you might be able to provide some guidance, and I appreciate any help you might be able to provide.

 

Anyway, the context is that I'm trying to filter Projects. Each Project is supposed to have a single task with a flag. I want to filter for the projects that have 0 or more than 1 of those tasks with the flag. Currently...

 

!any("task", task.priskey == 1, project.odf_pk, ctx)

 

...will show me all the projects that do not have at least one task with that flag. Can I do something like...

 

!any("task", count(task.priskey) == 1, project.odf_pk, ctx)

 

Thanks for any help you might be able to provide.

Outcomes