Red Hat Bugzilla – Bug 1470251
Anding of multiple filters does not product the required results
Last modified: 2017-07-19 13:55:04 EDT
An example query:
Running a query with each individual tag reveals the correct results. And so, one would imagine the above query would return all services with the both tag values, when in fact nothing is returned :(
Here's a pr awaiting a fix: https://github.com/ManageIQ/manageiq-ui-service/pull/840
Please assess the impact of this issue and update the severity accordingly. Please refer to https://bugzilla.redhat.com/page.cgi?id=fields.html#bug_severity for a reminder on each severity's definition.
If it's something like a tracker bug where it doesn't matter, please set it to Low/Low.
This looks to be a problem with the nature of the relationships being queried. I think officially we do not support queries like that based on one-to-many relationships. What it translates to is "find me all rows where the tag name is /managed/environment/dev AND /managed/location/ny", and since there are no rows where the tag name can be two different things it yields 0 results.
I can see that might be two actions to take on this:
1. We should update the documentation to make this limitation more clear
2. An API that wraps "CONTAINS" - type expressions would be a useful enhancement
DOH 2. would be what we're looking for, so not a bug, looking like something we should shelve for the time being