EXISIT Filter Example: Projects that don't have tasks with Predecessors | Community
Skip to main content
imgrund
imgrund
Employee
Oct 27, 2020 2:33 PM UTC
Question

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

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 😎 )

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

    2 replies

    NRYNR
    Level 10
    Oct 29, 2020 5:11 AM UTC

    + the WFPro Text Mode Examples catalog for future reference.

    Translate
      Doug_Den_Hoed__AtAppStore
      Doug_Den_Hoed__AtAppStore
      New Participant
      Oct 27, 2020 4:53 PM UTC

      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

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...