Text mode for task report to exclude tasks from programs containing certain words | Community
Skip to main content
N
NickVa7
Level 9
August 28, 2024
Question

Text mode for task report to exclude tasks from programs containing certain words

  • August 28, 2024
  • 1 reply
  • 902 views

Hi WF Community,

 

I'm looking to create a task report that excludes tasks from projects that belong to programs with the words "Non-Billable" in the program name.

 

The closest I've gotten on this is with the following text mode filter:

EXISTS:1:$$EXISTSMOD=NOTEXISTS
EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:ID=projectID
EXISTS:1:ID_Mod=in
EXISTS:1:program:name=Non-Billable
EXISTS:1:program:name_Mod=cicontains

 

It doesn't error when I run the report, but it doesn't filter out tasks from programs containing "Non-Billable" in the program name 😞

 

Any ideas on where I might be going astray?

Thanks!
Nick

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

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
August 28, 2024

I think you should just go with:


EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:ID=projectID
EXISTS:1:ID_Mod=in
EXISTS:1:program:name=Non-Billable
EXISTS:1:program:name_Mod=cinotcontains

N
NickVa7Author
Level 9
August 29, 2024

Thanks, Skye.  That looks logical, and the report doesn't error out, but it turns up zero records when run.  I tried taking out the "ci" (case insensitive), but same result.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
August 29, 2024

that's interesting. I got mine working yesterday -- I didn't use "billable" but I used the word "ad hoc" which turns up quite often. Obviously we're rather high volume, so I put in a task entry date filter for "today" so I could test with a smaller subset, but I tried both exists and notexists and these turned up two separate sets of tasks, one with tasks in ad hoc programs, and the other without. 

 

I did put in a column in the view, so I could see the task program names that are being pulled in. Other than this and without knowing your full set of filters, I can't comment, but I would definitely suggest you submit a case to support since I have heard that they love helping with reporting issues... 

Terms & ConditionsAccessibility statement

Loading footer...