Skip to main content
imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
October 27, 2020
Pregunta

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

  • October 27, 2020
  • 2 respuestas
  • 576 visualizaciones

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

    Este tema ha sido cerrado para respuestas.

    2 respuestas

    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

    Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
    N
    NRYNR
    Level 10
    October 29, 2020

    + the WFPro Text Mode Examples catalog for future reference.

      Términos y condicionesAccessibility statement

      Loading footer...