Negative Filter / Exception Filter

There would be many cases in which it would be useful to filter based on the absence of a value rather than the presence. E.g. I would like to filter all tasks due on any date except this week. Or tasks assigned to anyone except unassigned or except "Joe". For instance I have a few dummy users to which we assign major tasks to filter them for gantt charts to keep the charts from having every last memo on them. I don't want those dummy user to show up in my weekly staff meeting. 

Thanks.  

29
16 comments
Spot On Innovative Approach Stellar Advice
Avatar
Anastasia

Hi Eliza, thank you for posting this request! That's actually a great idea, and I think several users would be interested in voting for it. I especially appreciate the example with dummy users, thank you for sharing your use cases! :)

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

It's the must have feature.

1
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I assume this isnt in work yet?

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

@David, correct this hasn't been released and has not yet been added to the roadmap. If that changes we'll make sure to keep you updated here!

Stephanie Westbrook Community Team at Wrike Become a Wrike expert with Wrike Discover

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I'd really like to have a feature like this to help double check the data entry on projects and tasks. For example, I do not have a good way to pull a report letting me know if any of my projects are labelled as being project type X but not tagged with the appropriate folders for that type of project. Instead I have to pull a report of all projects of that type and manually read the parent folder column to see if they look correct.

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I'd love to see this feature too, especially as a way to remove folders or projects from filtered results. For example, show me all active tasks for this user that are in this folder and its subfolders and projects EXCEPT Project X. Don't show me any of the tasks from Project X.

We currently have one project that has over 100 tasks assigned to one person because it involves tracking a number of different documents through a round of editing, translation, re-editing, approval, etc. It would be great to exclude that project when looking at current tasks for example. We all know that there are a huge number of tasks involved, but it makes it difficult to sort through everything else.

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

in general the flexibility of filters shoud be improved!

what about adding filters like a script using AND, OR, ANDNOT ect. and giving access to all variables and fields available? Why are custom filters so limited???

4
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I also requested a special filter to see tasks assigned to more than one user (as this may cause problems and is strongly recommended to be avoided!)

https://help.wrike.com/hc/en-us/community/posts/360028595334-Filter-for-tasks-with-multiple-assignees

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I strongly support this feature request. This would help in many cases.

1
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Implementation recommendation: Filtering with logical operators is an advanced function. For that reason, it is appropriate to adopt an interface with a *slightly* higher learning curve. Rather than adding complexity to your GUI with additional options, give your "power users" the option to enter filter criteria as text. Most will be comfortable forming logical statements in text form based on their experience with refining search engine queries..

1
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

We really need the ability to exclude results based on filter. At the very least give us access to see the search script that is generated and add to it as you can in Jira

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi everyone! Our team definitely considers this an interesting suggestion, it's simply not planned for the short-term roadmap. I'll let you know when/if that changes! 

Lisa Community Team at Wrike Become a Wrike expert with Wrike Discover

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

This would be really useful for me to use with the Last Modified Date filter. I am having a hard time setting up a report that would list all my assigned tasks that I have not updated this week.

1
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Hugh

Thank you for sharing this feedback, Kyle Shertzer!

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I have a multiple choice field that has several options (100+). I am trying to exclude one option for dashboard and report purposes. If there weren't so many options, I would filter for "Contains Any", and select all the options except for the option that I am looking to exclude.

Since there are so many, I at least wish that there was a "select/deselect all" feature when filtering, but overall I especially agree with what Eliza and Florian have expressed.

0
Comment actions Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Hugh

Hey Cammille,

Thank you for sharing this use case here, it's been shared with the Product team.

No update here at the moment - if there is any new information, I'll be sure to let you know.

mdr

1
Comment actions Permalink

Folllowing List for Post: Negative Filter / Exception Filter
[this list is visible for admins and agents only]

Didn’t find what you were looking for? Write new post