MongoDB在golang中查找$ or和$ and组合的查询

Question

I want to get rows where:

{repair field has "ac" OR {repair is "tv" and phone field in range 1091-1100}}

I am trying the following query:

type M map[string]interface{}
conditions := M{"name": M{"$regex": "me"},
    "$or": []M{M{"repair": M{"$eq": "ac"}},
"$and": []M{M{"repair": M{"$eq": "tv"}}, M{"phone": M{"$gte": 1091, "$lte": 1100}}}}}
    fmt.Println(conditions)
    err = c.Find(conditions).Sort("phone").Limit(20).All(&j)

However, I am getting a compile error:

index must be non-negative integer constant
cannot use []M literal (type []M) as type M in array or slice literal.

Answer 1

You're missing one M{ before "$and" and after you add that don't forget to add another closing brace }.

the good and the bad for comparison.