コミュニティアチーブメントバーを展開する。

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

この会話は、活動がないためロックされています。新しい投稿を作成してください。

解決済み

Filter: not blank AND not 'x'

Avatar

Level 3
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
トピック

トピックはコミュニティのコンテンツの分類に役立ち、関連コンテンツを発見する可能性を広げます。

1 受け入れられたソリューション

Avatar

正解者
Level 10

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 返信

Avatar

Level 3

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

Avatar

Employee
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

Avatar

Level 10

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

Avatar

Level 3

Yay for WF-pro.com!!!

Avatar

正解者
Level 10

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.