Filtering by fields in an Array of Objects
Currently if you have an array of objects you cannot filter by the values of those objects. Charts concatenates all of the values in that field together.
For instance, if the structure looks like this:
{ owners:
[
{"name": "Bob Smith",
{"address": 123 Main St.},
{"name": "Janet Smith",
{"address": 321 Other St.}
]
}
The available filter for name would be "Bob SmithJanet Smith", which returns no results.
2
votes
Tom
shared this idea
This is now fixed in the latest Atlas release, and will be included in the next on-prem release in December 2019.