Proper way of using $or operator in mgm

[amirhossein-shakeri]

Imagine we have a model & a collection of docs. How do we use $or operator to combine queries and retrieve multiple docs?🤔

type Person struct {
	Name   string  `json:"name" bson:"name"`
	Age    int     `json:"age" bson:"age"`
	Weight float64 `json:"weight" bson:"weight"`
}

Forexample we need to get all docs which have an age of above 20 OR their weight is less than 70, then what is the best way to do that using mgm?🤔

[mehran-prs]

Hi @amirhossein-shakeri-work
It can be something like this:

type Person struct {
	mgm.DefaultModel `bson:",inline"`
	Name             string  `json:"name" bson:"name"`
	Age              int     `json:"age" bson:"age"`
	Weight           float64 `json:"weight" bson:"weight"`
}

func main() {
	persons := make([]*Person, 0)
	err := mgm.Coll(&Person{}).SimpleFind(&persons, bson.M{"$or": bson.A{
		bson.M{"age": bson.M{"$gt": 20}},
		bson.M{"weight": bson.M{"$lt": 70}},
	}})
}

[amirhossein-shakeri]

Now, I know how to use Mongo operators through mgm. Thanks!

[mehran-prs]

You're welcome @amirhossein-shakeri-work :)