Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

Exists Syntax

Avatar

Level 4
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 -
0 Replies