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

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

  • June 11, 2024
  • 1 reply
  • 1182 views

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.
Best answer by lgaertner

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

1 reply

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

    N
    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"

    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

     

    Terms & ConditionsAccessibility statement

    Loading footer...