And you can combine this with other filters
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=ASSGN
EXISTS:a:assignedToID_Mod=isblank
EXISTS:a:roleID=58bdc087000775373be69ebe12a1df11
EXISTS:a:taskID=FIELD:ID
project:statusEquatesWith=CUR
project:statusEquatesWith_Mod=in
And last one for the crazy: Unassigned Tasks For My Role in Current Projects
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
project:statusEquatesWith=CUR
project:statusEquatesWith_Mod=in
All reportable objects on the same project as the user
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=PRTU
EXISTS:a:projectID=FIELD:projectID
EXISTS:a:userID=$$USER.ID
All reportable objects where the specified team is assigned to the project
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=ASSGN
EXISTS:a:teamID=
EXISTS:a:projectID=FIELD:projectID
Notes tagged to the current user
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=NTAG
EXISTS:a:noteID=FIELD:ID
EXISTS:a:userID=$$USER.ID
Can we do a briefs folder contains documents?
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=DOCFLD
EXISTS:a:projectID=FIELD:ID
EXISTS:a:folder:name=Briefs
EXISTS:a:folder:name_Mod=cicontains
categoryID=5a678fa309321b15d369d2843bb6b521
categoryID_Mod=in
Projects I own but I'm not a resource manager
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=RESMGR
EXISTS:a:projectID=FIELD:ID
EXISTS:a:resourceManagerID=$$USER.ID
ownerID=$$USER.ID
Users without any active assignments
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 -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site:
www.capabilitysource.com email: melinda.layten@capabilitysource.com Helpful? Buy me a coffee:
https://www.patreon.com/mlayten - we simplify your work so you can run your business -
