If you’re interested in more training resources, give 𝕎𝔽ℙ𝕣𝕠 𝕌𝕟𝕚𝕧𝕖𝕣𝕤𝕚𝕥𝕪 a try.
Resources
- How To Add the EXISTS Mod to a Filter – Lean the fundamentals of how to build the filter(s).
Topics
- Projects Without Tasks on the Project
- Projects Without Documents on the Project
- Projects Without Issues on the Project
- Projects With a Task Named “Test”
- Projects With Documents
- Projects Without Tasks, Issues and Documents (Multiple)
- Hours Without Assignments Where Assigned To is the Hour Owner
- Assignments With Blank Assignee and My Role(s) on a Task
- Users Without Active Assignments Who Are Active Users
- Timesheets Without Hours
- Documents With Folder Named
- Projects With Active Tasks or Issues Assigned to Me
- Custom Fields/Parameters Without a Custom Form/Category
- Projects WITH Active Portfolio Owner
Projects Without Tasks on the Project
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=TASK EXISTS:a:projectID=FIELD:ID
Projects Without Document(s) on the Project
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=DOCU EXISTS:a:projectID=FIELD:ID
Projects Without Issues on the Project
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=OPTASK EXISTS:a:projectID=FIELD:ID
Projects With a Task Named “test”
EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=TASK EXISTS:a:projectID=FIELD:ID EXISTS:a:name=test
Projects With Document(s)
With EXISTS:a:$$EXISTSMOD=EXISTS Tasks EXISTS:a:$$OBJCODE=DOCU On the Project EXISTS:a:projectID=FIELD:ID
Projects Without Tasks, Issues and Document(s) on the Project (Multiple)
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=TASK EXISTS:a:projectID=FIELD:ID EXISTS:b:$$EXISTSMOD=NOTEXISTS EXISTS:b:$$OBJCODE=OPTASK EXISTS:b:projectID=FIELD:ID EXISTS:c:$$EXISTSMOD=NOTEXISTS EXISTS:c:$$OBJCODE=DOCU EXISTS:c:projectID=FIELD:ID
Hours Without Assignments Where Assigned To is the Hour Owner
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=ASSGN EXISTS:a:assignedToID=FIELD:ownerID EXISTS:a:taskID=FIELD:ID
Assignments With Blank Assignee and My Role(s) on a Task
EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=ASSGN EXISTS:a:assignedToID_Mod=isblank EXISTS:a:roleID=$$USER.roleIDs EXISTS:a:roleID_Mod=in EXISTS:a:taskID=FIELD:ID
Users Without Active Assignments Who Are Active Users
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=ASSGN EXISTS:a:assignedToID=FIELD:ID EXISTS:a:status=AA AD EXISTS:a:status_Mod=in isActive=true isActive_Mod=eq
Timesheets Without Hours
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=HOUR EXISTS:a:timesheetID=FIELD:ID
Documents in Folder Named
EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=DOCFLD EXISTS:a:documentID=FIELD:ID EXISTS:a:folder:name=YOUR_FOLDER_NAME EXISTS:a:folder:name_Mod=cicontains
Projects With Active Tasks or Issues Assigned to Me
statusEquatesWith=CPL DED statusEquatesWith_Mod=notin EXISTS:b:$$EXISTSMOD=EXISTS EXISTS:b:$$OBJCODE=OPTASK EXISTS:b:projectID=FIELD:ID EXISTS:b:actualCompletionDate_Mod=isnull EXISTS:b:assignmentsUsersMM:ID=$$USER.ID EXISTS:b:assignmentsUsersMM:ID_Mod=in OR:1:statusEquatesWith=CPL DED OR:1:statusEquatesWith_Mod=notin OR:1:EXISTS:a:$$EXISTSMOD=EXISTS OR:1:EXISTS:a:$$OBJCODE=TASK OR:1:EXISTS:a:projectID=FIELD:ID OR:1:EXISTS:a:actualCompletionDate_Mod=isnull OR:1:EXISTS:a:assignmentsUsersMM:ID=$$USER.ID OR:1:EXISTS:a:assignmentsUsersMM:ID_Mod=in
Custom Fields/Parameters Without Custom Forms/Categories (Parameter Report)
EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=CTGYPA EXISTS:a:parameterID=FIELD:ID
Projects With Active Portfolio Owner (ProjectReport)
EXISTS:1:$$OBJCODE=PORT EXISTS:1:ID=FIELD:portfolioID EXISTS:1:owner:isActive=TRUE