Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 8

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? 

1 Accepted Solution

Avatar

Correct answer by
Level 3

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

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