Report Filter: Contains and Does Not Contain on the same field | Community
Skip to main content
NickVa7
Level 9
June 11, 2024
Solved

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
lgaertner
lgaertnerAccepted solution
Level 9
June 11, 2024

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

View reply

4 replies

lgaertner
lgaertnerAccepted solution
Level 9
June 11, 2024

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

Translate
    NickVa7Author
    Level 9
    June 11, 2024

    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"

    Translate
    lgaertner
    lgaertner
    Level 9
    June 11, 2024

    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

     

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...