Skip to main content
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.

5 replies

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
kynabaker16
Adobe Employee
Adobe 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
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
Level 2
Apr 16, 2020 7:30 PM UTC

Yay for WF-pro.com!!!

Translate
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