Text Mode in Filters Using EXISTS Mod

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