Report Filter: Contains and Does Not Contain on the same field

[NickVa1]

Hi WF Community,

I'm trying to create multiple filters in a report, filtering on the same field (Program Name).

- I want results where the Program Name contains "AXP371"

**AND**

- I want results where the Program Name does not contain "enl"

When I do this, whether in the standard interface or using text mode, the system strips out one of the Program Name filters.  Does anyone know if it's possible to create a report with this filtering?

Thanks!
Nick

[lgaertner · Accepted solution]

Hello Nick,

you are right, using the UI one of the filters seems to be ignored, but using text mode with AND:1: works, if I do not miss anything:

name=AXP371
name_Mod=cicontains
AND:1:name=enl
AND:1:name_Mod=notcontains

Regards

Lars

[NickVa1]

Nice, that worked, thanks Lars!

Can I add an OR in that text mode so the whole query solves for the following:

This is the first part you helped me solve for already...

- I want results where the Program Name contains "AXP371"

**AND**

- I want results where the Program Name does not contain "enl"

This is the second part I want to add as an OR (in addition to the above)...

**OR**

- I want results where the Program Name contains "AXP371"

**AND**

- I want results where the Program Name does not contain "early engagement"

[lgaertner]

Hello,

without having it tested in detail, this could work:

name=AXP371
name_Mod=cicontains
AND:1:name=enl
AND:1:name_Mod=notcontains
OR:2:name=AXP371
OR:2:name_Mod=cicontains
AND:2:name=early engagement
AND:2:name_Mod=notcontains

Regards

Lars

[NickVa1]

Thanks, Lars.  No luck so far with that 2nd one, but looking into it.