Can't have task name 'contains' and 'doesn't contain' filter in same report? | Community
Skip to main content
Madalyn_Destafney
Community Advisor
Community Advisor
January 11, 2023
Solved

Can't have task name 'contains' and 'doesn't contain' filter in same report?

  • January 11, 2023
  • 1 reply
  • 967 views

Hi all, I have a task report that I want to use a task name 'contains' filter AND also a task name 'does not contain' filter so that I'm pulling in certain tasks, but not a certain (consistent) iteration of that task name. When I added the 'does not contain' filter, it overrides the existing 'contains' filter. Is it true I can't have a contains and does not contain in a report?? 

I also tried using an OR filter set for all the same other filters and 1 set with the 'contains' and the other set with the 'does not contain' and not pulling what I need. Is there a way in text mode or something I can have these different task name filters? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by lgaertner

Hello Madalyn,

 

I can confirm the described behaviour, that adding a second filter on the name does remove the first one.

 

You can try to achieve it using Text mode (here to show tasks which names contain keyword1 but not keyword2 )

 

 

name=keyword1 name_Mod=cicontains AND:1:name=keyword2 AND:1:name_Mod=cinotcontains

 

 

Regards

Lars

1 reply

lgaertner
lgaertnerAccepted solution
Level 9
January 12, 2023

Hello Madalyn,

 

I can confirm the described behaviour, that adding a second filter on the name does remove the first one.

 

You can try to achieve it using Text mode (here to show tasks which names contain keyword1 but not keyword2 )

 

 

name=keyword1 name_Mod=cicontains AND:1:name=keyword2 AND:1:name_Mod=cinotcontains

 

 

Regards

Lars

Madalyn_Destafney
Community Advisor
Community Advisor
January 18, 2023

Thanks a bunch, that worked!

If this helped you, please mark correct to help others : )