Wildcard in aggregation acting Funny

My docs (movies) are in this kind of format:

    "title" : "title of movie",
    "cast": [list of names],
    "genres": [list of genres],
    "year" : long

Now i have attached the query that i performed and the results it showed me. and it seems the wildcard is not working properly. for example when searching for names ending with "rell"
i used "*rell" in wildcard but it returned name that did not end with rell !
Please help

you can see in the bottom left the name janet gaynor also appeared !

The reason is cast array(or list) is stored as a single document. You can split the array into multiple individual documents or use parent-child join.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.