/Javascript/Node.js/Search with multiple field in node js mongodb

Search with multiple field in node js mongodb

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()

Source: stackoverflow.com

Search with multiple field in node js mongodb

> db.test.find({$or: [{Description: {$regex: '^225/65R16'}, Brand: {$regex: '^Hankook'}}]})
{ "Description" : "225/65R16 71T K715", "Brand" : "Hankook", "Ref" : 123455 }
{"Description" : "225/65R16 94T", "Brand" : "Hankook", "Ref" : 123455 }

> db.test.find({$or: [{Description: {$regex: '^225'}, Brand: {$regex: '^Han'}}]})
{ "Description" : "225/65R16 71T K715", "Brand" : "Hankook", "Ref" : 123455 }
{ "Description" : "225/65R16 94T", "Brand" : "Hankook", "Ref" : 123455 }

Source: stackoverflow.com

Similar codes

1 vote197 views1 answer
Introdução ao nodeJs
Javascript Node.js
0 vote207 views1 answer
Node save wav base64
Javascript Node.js
16 votes211 views4 answers
Mongoose connection nodejs
Javascript Node.js
0 vote190 views1 answer
Nodejs css cotent tipe
Javascript Node.js
5 votes195 views2 answers
Node js get ip
Javascript Node.js
0 vote204 views1 answer
How to get user info from google oauth node js
Javascript Node.js
42 votes231 views3 answers
How to generate random string in node js
Javascript Node.js
14 votes206 views1 answer
Node console colors
Javascript Node.js
0 vote204 views2 answers
Babel, babel nodejs, config babel,
Javascript Node.js
0 vote211 views1 answer
Gps nodejs
Javascript Node.js