/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

0 vote183 views1 answer
How to generate a random salt in nodejs
Javascript Node.js
7 votes189 views3 answers
How to get file name in directory node js
Javascript Node.js
0 vote176 views1 answer
Access to XMLHttpRequest has been blocked by CORS policy node js
Javascript Node.js
1 vote159 views1 answer
Node js cron example
Javascript Node.js
0 vote168 views1 answer
How to find the radius of a loacation in node js
Javascript Node.js
102 votes301 views4 answers
Node json stringify
Javascript Node.js
1 vote176 views2 answers
Model export in node js
Javascript Node.js
0 vote207 views2 answers
How to create response time router node js
Javascript Node.js
6 votes213 views3 answers
Nodejs request api
Javascript Node.js
0 vote120 views1 answer
Nodejs object object template string
Javascript Node.js