Operator $or(query) and operator $(projection) don't work together.

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Minor - P4
    • None
    • Affects Version/s: 3.0.4
    • Component/s: Querying
    • None
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      QUERY:

      db.users.find({
                            $or: [
                                {
                                        _id: senderId,
                                        "_contacts._profile_id": recipientId
                                },
                                {
                                    _id: recipientId,
                                    "_contacts._profile_id": senderId
                                }
                            ]
},
{
"_contacts.$": 1
})

      ERROR:
      BadValue positional operator (_contacts.$) requires corresponding field in query specifier","code":17144} must be equivalent to undefined

            Assignee:
            Wan Bachtiar
            Reporter:
            Roman
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: