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
Like this:
Like Loading...