EXISIT Filter Example: Projects that don't have tasks with Predecessors | Community
Skip to main content
imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
October 27, 2020
Question

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

  • October 27, 2020
  • 2 replies
  • 548 views

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

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    October 27, 2020

    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

    N
    NRYNR
    Level 10
    October 29, 2020

    + the WFPro Text Mode Examples catalog for future reference.

      Terms & ConditionsAccessibility statement

      Loading footer...