Affects Version/s: None
Fix Version/s: None
The following query works as expected:
Returning a bunch of data:
However a query using "in" that should produce the same result, produces no results:
This behaviour contradicts the documentation where it says:
The in operator matches a field, or set of fields against either an array or a subquery.
The in operator can be used in two ways. The simplest way is to see if a field, contains one of the values provided in a list of literal values: