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

Forum|Forum|1 year ago
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.

skyehansen

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

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

For anyone referencing this in the future, here is the final text mode that worked:

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

Thanks Skye for getting me on the right path. The only item missing from your original suggestion was "FIELD" in the second row.

d'oh! -- typo.... I copied from your original code instead of from my test sample because I was too lazy to retype "Non billable"

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded