Filter: not blank AND not 'x' | Community
Skip to main content
G
GalenMa
New Participant
September 10, 2019
Solved

Filter: not blank AND not 'x'

  • September 10, 2019
  • 4 replies
  • 1563 views
Hi all. Can anyone recommend a way to create the following type of filter?... I want to filter out everything where valueA is not equal to 'x' (Mod=notin) but I ALSO want to filter out everything where valueA is not blank (Mod=notblank) How would I get both in the same filter? Galen Malick JLL
    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 SkyeHa

    thanks Galen, just used this in one of my reports and (typical--for us) had to add on in the following manner because we were doing several sets of filters. But -- it does work even on multiple sets. Very nice.

    <field>_Mod=notblank

    AND:1:<field>=<value>

    AND:1:<field>_Mod=notin

    OR:1:<field>_Mod=notblank

    AND:2:<field>=<value>

    AND:2:<field>_Mod=notin

    OR:2:<field>_Mod=notblank

    AND:3:<field>=<value>

    AND:3:<field>_Mod=notin

    and so on.

    4 replies

    S
    SkyeHaAccepted solution
    New Participant
    September 21, 2019

    thanks Galen, just used this in one of my reports and (typical--for us) had to add on in the following manner because we were doing several sets of filters. But -- it does work even on multiple sets. Very nice.

    <field>_Mod=notblank

    AND:1:<field>=<value>

    AND:1:<field>_Mod=notin

    OR:1:<field>_Mod=notblank

    AND:2:<field>=<value>

    AND:2:<field>_Mod=notin

    OR:2:<field>_Mod=notblank

    AND:3:<field>=<value>

    AND:3:<field>_Mod=notin

    and so on.

      N
      NRYNR
      New Participant
      September 10, 2019

      Hi Galen, this is good. I've added it to the WFPro Text Mode site. Thanks, Narayan Narayan Raum Workfront Delivery Lead - SunTrust Bank https://wf-pro.com for Text Mode & Solutions

        H
        HrugDe
        New Participant
        April 16, 2020

        Yay for WF-pro.com!!!

          kynabaker16
          kynabaker16
          Employee
          September 10, 2019
          This is very helpful! Thank you for sharing and I'm so glad you figured out the solution! Kyna Baker Customer Content and Community Manager Workfront
          G
          GalenMaAuthor
          New Participant
          September 10, 2019

          I learned the solution, but I'm leaving this in the forum in case others need the same thing. In text mode, you can enter AND:1:<your field name> to reference the same field more than once. This allows me to do both a notin and a notblank for the same field. In my case, I used

          <field>_Mod=notblank

          AND:1:<field>=<value>

          AND:1:<field>_Mod=notin

          Terms & ConditionsAccessibility statement

          Loading footer...