I need to create a report that shows me all projects where my Custom Field of Proof Readers is blank AND contains the task of Get Packaging Creative Approved and DOES NOT contain Creative Approval. I can get halfway there but am struggling with the OR statement. I think I am missing something simple. Anyone has any ideas. Here is my starter code below.
DE:Proof Readers_Mod=isblank
ownerID=5a32f0cb00a0590561332aebaa9123cc
ownerID_Mod=notin
portfolioID=59a8a63f006e5d51bcd91ed4a25556d2
portfolioID_Mod=in
status=CUR
status_Mod=in
tasks:name=Get Packaging Creative Approved
tasks:name_Mod=cicontains
tasks:status=NEW INP
tasks:status_Mod=in
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi Tammy,
I'm going to see if @Sarah Nau‚ or @Jonathan Hobbs‚ who are both great at reporting have any ideas for you here!
Thanks in advance guys for seeing if you can help out.
Kyna
Views
Replies
Total Likes
My guess is, "Creative Approval" is the task name?
If you want to filter for projects where a creative approval task is missing, that would be an exists statement added to your textmode. You can read more about exists statements here: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...
You are specifically looking for this section: "You must use an EXISTS statement to do the following:
It might be as simple as just adding the four lines below to your code, but I would definitely test this before relying on it.
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:name=Creative Approval
EXISTS:a:projectID=FIELD:ID
Views
Replies
Total Likes
Views
Like
Replies