Text Mode in Filters Using EXISTS Mod

Resources

Topics

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