EXISTS filter on a project report

Hi - so below is the info from my "cheat sheet" when it comes to EXIST filters. (You'll want the moving down the Hierarchy)

However, I'm not sure you can do multiple Contains filters. I think I remember reading in a post on Community once, that it doesn't work. But try it. You will just repeat the EXIST filter but change the 1's to 2's (and then to 3's for the third one).

Moving Up The Hierarchy

This is for reports where you want to jump up more than one level. (Like show me projects where the portfolio owner is no longer active)

EXISTS:1:$$OBJCODE=[Insert the Object Code for Reference]

EXISTS:1:[Reference Object Type's field that matches current object]=FIELD:[Current Object Type's field that matches reference object]

EXISTS:1:[Field on Reference being filtered]=[Condition]

Based on my Example:

EXISTS:1:$$OBJCODE=PORT

EXISTS:1:ID=FIELD:portfolioID

EXISTS:1:owner:isActive=False

Showing Items Not Selected

This is for reports where you want to show items where a multiple-select option is NOT selected (Like projects that are not Digital)

EXISTS:1:$$OBJCODE=[Current Object Code]

EXISTS:1:ID=FIELD=ID

EXISTS:1:[Custom Field You Are Filtering On]=[What the TRUE expression would be]

EXISTS:1:$$EXISTSMOD=NOTEXISTS

Based on my Example:

EXISTS:1:$$OBJCODE=PROJ

EXISTS:1:ID=FIELD=ID

EXISTS:1:DE:Type of Project=Digital

EXISTS:1:$$EXISTSMOD=NOTEXISTS

Moving Down The Hierarchy

This is for reports where you want to apply a filter based on a many-to-one relationship (Like portfolios that have projects Anthony owns)

EXISTS:1:$$OBJCODE=[Insert Object Code for the Collection]

EXISTS:1:[Collection Object Type's field that matches current object]=FIELD:[Current Object Type's field that matches collection object]

EXISTS:1:[Field on Collection being filtered]=[Condition]

Based on my Example:

EXISTS:1:$$OBJCODE=PROJ

EXISITS:1:portfolioID=FIELD:ID

EXISTS:1:ownerID=532376910024d8443277c3e46ed5330a

Thanks for this, Anthony! While I was waiting to see if anyone would answer this, it looks like I came up with something similar to what you have listed at the end of your response....

EXISTS:1:$$EXISTSMOD=CICONTAINS

EXISTS:1:$$OBJCODE=TASK

EXISTS:1:name=QA

EXISTS:1:projectID=FIELD:ID

Thanks for the info, and the note about adding 1, 2, 3 for multiple contains. I'll let you know if it works. So far, the above, single-contains, filter works.

Hmmm, @Kyna Baker - inactive‚ , do you think Tony Messam might know if I can do multiple contains in an EXISTS filter? I tried the following and it doesn't seem to be working:

EXISTS:1:$$EXISTSMOD=CICONTAINS

EXISTS:1:$$OBJCODE=TASK

EXISTS:1:name=QA

EXISTS:1:projectID=FIELD:ID

EXISTS:2:$$EXISTSMOD=CICONTAINS

EXISTS:2:$$OBJCODE=TASK

EXISTS:2:name=Quality Assurance

EXISTS:2:projectID=FIELD:ID

EXISTS:3:$$EXISTSMOD=CICONTAINS

EXISTS:3:$$OBJCODE=TASK

EXISTS:3:name=Proof

EXISTS:3:projectID=FIELD:ID

That's a good question! @Anthony Messam‚ have you ever run across something like this and can share your EXISTS expertise??

Yes! That's the money, Tony!! Thanks for explaining, too.

Please forgive me for resurrecting an old thread, but I am trying to find an answer (or a resource to teach me) and this had the best example to use.

If Nick HAD needed to use the EXISTS, what does the structure look like with the OR statement? I am trying to modify a filter on our Projects tab which currently uses exists to list Projects assigned with specific criteria to a user, but I'd like it to include (as an OR) as separate scenario where the next Task AFTER the assigned Task is still not complete (it's assigned to someone else). Trying to catch any that are missing the last step specifically in the user's Project list.

Is it EXISTS:OR:B:_________? (The first set is A). Not sure how this should properly be laid out.

Thank you!