I am using $match with aggregation method but not getting correct results. I am getting 26 results if I use $nin in genres field and 32 if I use $ne. I have spent lot of time to fix this but not able to do.
I think I am not able to understand the question a bit
- imdb.rating is correct. i.e less than or equal to 7
- genres -> It should not contain both “Crime” or “Horror” or we can have either one of them. As I understood either “Crime” should be their or “Horror”. We can not have both of them in genres field
- rated is correct -> Its either “PG” or “G”
- languages -> Its also correct, it contains “English” and “Japanese”