Hi folks, I’m not really sure why my simple query is not working. I just loaded a new collection into my atlas database. And a very simple filter inside compass is not working.
my collection has a nested object platform
when I use { “platform” : { “_id” : 1} as a filter, no results are found. It does not matter what property I use.
Filters are also not matching any other array elements such as genres. Am I missing something very obvious and silly here?
Thanks
Just wanted to add another point, the data is being loaded via java with the mongo driver using pojo codec.
If I insert one document via the atlas ui, using the exact same structure, then the query finds the data. Not sure if there’s a problem with the pojo codec, but the data entered manually does not appear to be any different from the one in the collection.