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
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
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"
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Thanks, Lars. No luck so far with that 2nd one, but looking into it.
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies