Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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.
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
Views
Replies
Total Likes
Views
Replies
Total Likes
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
Yay for WF-pro.com!!!
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.
Views
Likes
Replies