Project Report to Pull Project that has none of its Tasks Started yet | Community
Skip to main content
A
Abka
July 15, 2025
Solved

Project Report to Pull Project that has none of its Tasks Started yet

  • July 15, 2025
  • 2 replies
  • 394 views

Hi,

I am trying to build a workfront report that Pulls in List of Projects that are in Planning Status and None of the underlying Task is started yet, i.e all Tasks on such Project should be in New Status.

 

Appreciate the help

Best answer by -JC

Hi @abka, you would leverage an Exists statement to accomplish this by essentially saying "show me all projects, with a status of Planning, where no tasks exist that are in a status other than New". 

 

So, in a Project report, you would add the following text mode code to the filter:

 

status=PLN status_Mod=in EXISTS:A:$$EXISTSMOD=NOTEXISTS EXISTS:A:$$OBJCODE=TASK EXISTS:A:projectID=FIELD:ID EXISTS:A:status=NEW EXISTS:A:status_Mod=notin

 

More info here: https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/create-complex-text-mode-filters-using-exists-statements

2 replies

-JC
-JCAccepted solution
Level 6
July 15, 2025

Hi @abka, you would leverage an Exists statement to accomplish this by essentially saying "show me all projects, with a status of Planning, where no tasks exist that are in a status other than New". 

 

So, in a Project report, you would add the following text mode code to the filter:

 

status=PLN status_Mod=in EXISTS:A:$$EXISTSMOD=NOTEXISTS EXISTS:A:$$OBJCODE=TASK EXISTS:A:projectID=FIELD:ID EXISTS:A:status=NEW EXISTS:A:status_Mod=notin

 

More info here: https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/create-complex-text-mode-filters-using-exists-statements

    A
    AbkaAuthor
    July 16, 2025

    Thanks a lot :-). That worked

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      September 22, 2025

      @abka  we noticed your question and invite you to our [Workfront AMA] Ask Me Anything about Workfront System Smarts & Strategic Starts on Wed, Oct 29, 2025 | 9–10 AM PDT. Experts will answer questions on topics like: day-to-day system tasks, strategic planning, Reporting, Adoption, System Maintenance, Notifications, Governance, Roadmapping, and Custom Forms. Post your questions in advance to ensure they’re answered. Reminder: All AMAs are TEXT-ONLY—no video or recording. RSVP & submit questions in advance here: https://adobe.ly/46xKfHM 

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...