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

Filter: not blank AND not 'x'

  • September 10, 2019
  • 4 replies
  • 1569 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

    G
    GalenMaAuthor
    Level 2
    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

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe 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
    N
    NRYNR
    Level 10
    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
      Level 2
      April 16, 2020

      Yay for WF-pro.com!!!

        S
        SkyeHaAccepted solution
        Level 10
        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.

          Terms & ConditionsAccessibility statement

          Loading footer...