Searching multiple fields in mongodb

Question

I have a mongo collection. Now a user can search using any field or all of the fields based on his needs.

For example :- A user can search using any one of attribute or any two attribute or any number of attribute he remembers of the fields present in the collection. Help me to decide which operator or combination of operators should I use?

{"_id":1, "field1":"hi","field2":"bye","field3":"bro", "field4":"stuff"},
{"_id":2, "field1": "hello", "field2": "back", "field3": "fat", "field4":"cat"},
{"_id":3, "field1": "some", "random": "foo", "stuff": "bar", "field4":"help"}

Jeet · Accepted Answer · 2017-11-21 18:16:00Z

Here you go -

db.test.find({
$or:[
    {
        $and: [
                {'stocknumber':12346},
                {'model':'bmx'},
                {'make':2002},
                {'rego':'KA01HG6268'},
                {'adate':'2017-10-01T05:07:10.969Z'},
                {'cdate':'2017-10-01T05:07:10.969Z'}
            ]
    },
    {
        $and: [
                {'stocknumber':12347},
                {'model':'bmy'},
                {'make':2003}
            ]

    }
]
}).pretty()

You can use combination of $and and $or in the above example $or acts as umbrella operator which let you execute any one query which ever combination user remembers, each query contains an $and operator which helps you to create combinations of fields user remember. This is going to be a lengthy query but better then a lot of null checks and string manipulation. In worst case it would be a Cartesian product of number of fields and both the operator. Hope this helps.

Alex P. · Accepted Answer · 2017-10-25 17:48:02Z

3

You'd have to wrap your parameters, that the user can search for, around an $or. Then every field that could be searched for has to use the $in operator.

db.getCollection('collection').find({
    $or: [
    {field1: {$in: ["hi", "hello", "some"]}},
    {field2: {$in: ["bye", "back", "some"]}},
    {field3: {$in: ["bye", "back", "some"]}},
    // etc. add your other fields as well here
    ]
})

answered Oct 25, 2017 at 17:48

Alex P.

3,1813 gold badges28 silver badges34 bronze badges

Comments

Antti_M · Accepted Answer · 2017-10-25 17:46:32Z

1

In MongoDB, you can make queries with and/or clauses.

For instance:

db.collection.find( { $or: [ { field1: "hi" }, { field1: "hello" } ] } )

answered Oct 25, 2017 at 17:46

Antti_M

98811 silver badges21 bronze badges

Collectives™ on Stack Overflow

Searching multiple fields in mongodb

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related