Project report filter for does not contain certain resource pools | Community
Skip to main content
N
NickVa7
New Participant
September 28, 2020
Solved

Project report filter for does not contain certain resource pools

  • September 28, 2020
  • 6 replies
  • 917 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by SarahNa

    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!

    6 replies

    N
    NickVa7Author
    New Participant
    October 5, 2020

    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.

    S
    SarahNa
    New Participant
    October 5, 2020

    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 😊

    N
    NickVa7Author
    New Participant
    October 5, 2020

    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?

    S
    SarahNaAccepted solution
    New Participant
    October 5, 2020

    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!

      N
      NickVa7Author
      New Participant
      October 5, 2020

      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

      S
      SarahNa
      New Participant
      September 29, 2020

      Hi Nick,

      Would this work?

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

      resourcePools:name_Mod=cinotcontains

        Terms & ConditionsAccessibility statement

        Loading footer...