Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

How to exclude from a list if a certain roleID is involved

Avatar

Level 2

I am looking at a list of projects and we need to exclude any that might have certain roles (e.g. "Email Role", or "Creative Role").    I am needing to create multiple views to allow teams to stack filters to identify which projects do not contain these specific compounded roles; results of projects would be any that included any number of different roles, just not the ones that were wanting to be excluded.  

 

Sample:  I want to create a view that does not bring these 2 projects in if they include this "web" team (and ultimately ability to stack to not include if specific teams are selected)

 

MichaelSMN_3-1732049731713.png

 

 

I tried to add a view where the project roleIDs does not equal and this only works if the only role in a project was for this web team.

MichaelSMN_2-1732049605450.png

 

 

I tried using text mode by adjusting the logic to something like the following where I was trying to show the list of projects if where this specific roleID(s) are not listed and had the same results where it only excluded if the roleID was exactly just that one role.

 

roleIDs=12f34567892f14547efbf73aa2fa4bef
roleIDs_Mod=cinotcontains

 

 

Any ideas? 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies