Filter Multiple Programs on Document Report

Question

I’m working on a document report with filtering for documents on tasks titled “Engineering Review” that are pending a task approval. I’m filtering out the process guides that are on the tasks, and would like to have these results span across multiple programs in the same portfolio. My text mode filter is:

AND:1:name=ApproverAND:1:name_Mod=notcontainsAND:2:name=ReviewerAND:2:name_Mod=notcontainsname=Process Guidename_Mod=notcontainsproject:portfolioID=XXXXXXXproject:programID=XXXXXXXproject:status=CURtask:name=Engineering Reviewtask:name_Mod=cicontainstask:pendingApproval=truetaskID_Mod=notblank

(Works great for just one program)

I’ve attempted to add an additional program ID as “project:programID=XXXXXXX,XXXXXXX” or as “OR:1:project:programID=XXXXXXX” in text mode. Neither has worked thus far. Am I off base for thinking that filtering multiple programs is possible? Any insights are appreciated.

Jared_Mauch · Accepted Answer

Did some more adjusting. This seems to be working on the report now.
AND:A:name=Approver

AND:A:name_Mod=cinotcontains

AND:B:name=Reviewer

AND:B:name_Mod=cinotcontains

AND:C:name=Process Guide

AND:C:name_Mod=cinotcontains

EXISTS:1:$$OBJCODE=TASK

EXISTS:1:ID=FIELD:taskID

EXISTS:1:name=Engineering Review

EXISTS:1:name_Mod=cicontains

EXISTS:1:pendingApproval=true

EXISTS:1:project:programID=68c804a700021a93326d4e046dfe41f7,68c82829000a6328983637ab353ad101

EXISTS:1:project:programID_Mod=in

taskID_Mod=notblank

ninoskuflic · Answer

Hi ​@Jared_Mauch, you should definetly be able to use OR statements. Can you try this?AND:A:name=ApproverAND:A:name_Mod=notcontainsAND:B:name=ReviewerAND:B:name_Mod=notcontainsname=Process Guidename_Mod=notcontainstask:name=Engineering Reviewtask:name_Mod=cicontainstask:pendingApproval=truetaskID_Mod=notblankOR:1:project:portfolioID=XXXXXXOR:1:project:programID=PROGRAM_1OR:1:project:status=CUROR:2:project:portfolioID=XXXXXXOR:2:project:programID=PROGRAM_2OR:2:project:status=CURWorkfront requires the entire filter to be restructured using OR groups that repeat the shared conditions.Here’s one example that I know 100% works from my personal cook-book. This is just to show you how OR statements work in Workfront text mode.😅This text mode syntax will filter your Proof Approval Report by specific portfolios. The OR statement is used so that you can filter by 2 different portfolios.EXISTS:1:$$OBJCODE=DOCUEXISTS:1:currentVersionID=FIELD:documentVersionIDEXISTS:1:project:portfolioID=653629d200052dadb928d883cbf9c21fOR:1:EXISTS:1:$$OBJCODE=DOCUOR:1:EXISTS:1:currentVersionID=FIELD:documentVersionIDOR:1:EXISTS:1:project:portfolioID=653629e8000530f0e9049918e4b117b4

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded