Filter: not blank AND not 'x' | Community
Skip to main content
GalenMa
Level 2
Sep 10, 2019 3:05 AM UTC
Solved

Filter: not blank AND not 'x'

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.
    SkyeHaAccepted solution
    Level 10
    Sep 21, 2019 3:37 AM UTC

    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.

    View reply

    5 replies

    SkyeHaAccepted solution
    Level 10
    Sep 21, 2019 3:37 AM UTC

    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.

    Translate
      NRYNR
      Level 10
      Sep 10, 2019 11:11 PM UTC

      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

      Translate
        HrugDe
        Level 2
        Apr 16, 2020 7:30 PM UTC

        Yay for WF-pro.com!!!

        Translate
          kynabaker16
          kynabaker16
          Employee
          Sep 10, 2019 6:26 PM UTC
          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
          Translate
          GalenMaAuthor
          Level 2
          Sep 10, 2019 5:43 PM UTC

          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

          Translate
          Terms & ConditionsAccessibility statement

          Loading footer...