EXISIT Filter Example: Projects that don't have tasks with Predecessors

[AnthonyIm]

Hi - a group admin for a smaller agency asked if I could do a report that shows projects that have no predecessors on them. This was a little more complicated than I thought due to the structure of the info on the backend, so I thought I'd share in case this comes up for anyone else.

EXISTS:1:$$EXISTSMOD=NOTEXISTS

EXISTS:1:$$OBJCODE=PRED

EXISTS:1:predecessor:projectID=FIELD:ID

(The part that threw me is that the reference of a predecessor is also called a predecessor when really it is just the task itself. Very weird. Thank god for the API Explorer 😎 )

[Doug_Den_Hoed__AtAppStore]

Very slick, Anthony -- thanks for sharing!

Along that same line of thinking, a NOTEXISTS that detected Projects with only Child Tasks (i.e. "no indenting") might be and interesting way of spotting (legit) simple/"checklist" Projects and/or (cluttery) "not-baked-yet" Projects, to then either finish off or delete the latter.

Regards,

Doug

[NRYNR]

+ the WFPro Text Mode Examples catalog for future reference.