2 weeks ago - last edited 2 weeks ago
Hello Community,
What is the correct way to combine multiple wildcard searches to produce all of the results I need when running a report in WEBi? For instance, I need to gather all inventory numbers beginning with 'AB', but also all inventory numbers beginning with 'CD', 'EF', and 'GH'. The screenshots below are two ways I have tried this, but the report always returns back no results at all. Thank you for your support!
Here is an updated screenshot as to where I'm able to get it to. I cannot double-click on the 'AND' to change it to an 'OR' though. Thanks again for taking a look!
Request clarification before answering.
You are not looking for a row that matches all of those patterns so just add each of your conditions with an OR instead of an AND. There is no reason to group them. You want:
Inventorynumber matches pattern "AB%"
OR Inventorynumber matches pattern "CD%"
OR inventorynumber matches pattern "EF%%"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for all the revisions. Its actually the ANDs between each condition that don't belong. Once you remove those, you should be able to double click and change that AND to an OR. It sometimes is easier to remove all the conditions and add them again the way you need them. You only need the 3 conditions with an OR at the left.
When you use the semi-colon there, it includes that as part of the pattern. Matches Pattern only accepts 1 value. I cannot explain how the extra ANDs are getting there. Simply dragging your object into the filter area 3 times, setting each to matches pattern, and then setting each ones pattern, should be all you need. Then double click the one and only AND to change it to an OR. Your original screen capture has 3 extra ANDs between each condition with nothing associated with them. It should look like this:
User | Count |
---|---|
54 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.