Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Project report filter for does not contain certain resource pools

Avatar

Level 9

Hi WF Community,

I'm trying to create a report that will show me projects that don't contain certain resource pool field values.

I tried using 'cinotcontains' as my text mode modifier, as this value was not available as a modifier in standard (filtering) mode, but this isn't working as expected.

Anyone know where I might be going astray?

Thanks.

Nick

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 7

Hey Nick,

You can add 'AND' statements for each one that you don't want:

resourcePools:name=<value you don't want>

resourcePools:name_Mod=cinotcontains

AND:1:resourcePools:name=<value you don't want 2>

AND:1:resourcePools:name_Mod=cinotcontains

AND:2:resourcePools:name=<value you don't want 3>

AND:2:resourcePools:name_Mod=cinotcontains

Good luck!

View solution in original post

6 Replies

Avatar

Level 7

Hi Nick,

Would this work?

resourcePools:name=<value you don't want>

resourcePools:name_Mod=cinotcontains

Avatar

Level 9

Thanks, Sarah. This does work; however, do you know how I can add multiple values in the resourcePools:name=<value you don't want> section? For example, I want to see projects that don't have:

  • Platform Dept.
  • QA Dept.
  • SolCon Dept.
  • Creative Dept.

Thanks.

Nick

Avatar

Correct answer by
Level 7

Hey Nick,

You can add 'AND' statements for each one that you don't want:

resourcePools:name=<value you don't want>

resourcePools:name_Mod=cinotcontains

AND:1:resourcePools:name=<value you don't want 2>

AND:1:resourcePools:name_Mod=cinotcontains

AND:2:resourcePools:name=<value you don't want 3>

AND:2:resourcePools:name_Mod=cinotcontains

Good luck!

Avatar

Level 9

Thanks again, Sarah. This is super close.

It works when:

a) I don't have any of the resource pools specified added to a project, but it has a resource pool outside my list

b) It has all of the resource pools specified added to a project, AND any other resource pool outside my list too

It doesn't work properly when:

a) There are no resource pools on a project at all (blank resource pools)

b) There are some of my specified resource pools but not all of them. Scenarios like this projects don't show up in the report.

Any ideas?

Avatar

Level 7

Hey Nick - why don't we hop on a call? I should be around for the next hour or so - shoot me an e-mail at sarah.nau@dominiuminc.com and we can get this figured out 😊

Avatar

Level 9

Sarah is the best! Thanks for taking time to help me out. We have this report in a good place, I just need to tweek it slightly.