how to use variable as a field value in mongodb query?

Question

how to use search_key variable as field value instead of static value BRO

if(search_key!=''){

  dbo.collection("assets").aggregate([
    { 
      "$match": {  $and: [ { status: 1 }, { $or: [ { maker_name : /^.*BRO.*$/i }, { serial_number : /^.*BRO.*$/i  } ] } ] }
    },  
    {
      $lookup:
       {
         from: 'asset_type',
         localField: 'asset_type',
         foreignField: 'asset_type_id',
         as: 'asset_type_details'
       }
     }
    ]).sort({_id:-1}).toArray(function(err, result) {
    if (err) throw err;
    res.status(200).json({'return_data': result });
    db.close();
  });

}

score 0 · Answer 1 · answered Nov 14 '18 at 12:22

We need to pass a string to the function. so we can simply change that by passing query string.

        if(search_key!=''){
            let query_string = "/^.*" + search_key + ".*$/i" // we are creating the query string here
            dbo.collection("assets").aggregate([
                { 
                    "$match": {  $and: [ { status: 1 }, { $or: [ { maker_name : query_string }, { serial_number : query_string } ] } ] }
                },  
                {
                    $lookup:
                     {
                       from: 'asset_type',
                       localField: 'asset_type',
                       foreignField: 'asset_type_id',
                       as: 'asset_type_details'
                     }
                 }
                ]).sort({_id:-1}).toArray(function(err, result) {
                if (err) throw err;
                res.status(200).json({'return_data': result });
                db.close();
            });

        }

score 0 · Answer 2 · answered Nov 14 '18 at 12:22

0

try like this :

if(search_key!=''){

  dbo.collection("assets").aggregate([
    { 
      "$match": {  $and: [ { status: 1 },
                           { $or: [ 
                            { maker_name : '/^.*'+ search_key +'*$/i' },
                            { serial_number : '/^.*'+ search_key +'*$/i'  } 
                            ]
                           }  
                         ]
                }
    },  
    {
      $lookup:
       {
         from: 'asset_type',
         localField: 'asset_type',
         foreignField: 'asset_type_id',
         as: 'asset_type_details'
       }
     }
    ]).sort({_id:-1}).toArray(function(err, result) {
    if (err) throw err;
    res.status(200).json({'return_data': result });
    db.close();
  });

}

answered Nov 14 '18 at 12:22

Saurabh Mistry

12,833
5
50
71

this is also not working – Nabin Samanta Nov 14 '18 at 12:31
Are you getting some error ? – Saurabh Mistry Nov 14 '18 at 12:38
show , what output are u getting ? – Saurabh Mistry Nov 14 '18 at 12:38
getting no error but no result – Nabin Samanta Nov 14 '18 at 12:53

score 0 · Accepted Answer · answered Nov 14 '18 at 13:02

0

Try this way

{ serial_number: { $regex: `${search_key}.*`, $options: 'i' } }

Use this same thing for maker_name also.

This is works for me.

answered Nov 14 '18 at 13:02

Sachin Shah

4,503
3
23
50

yes its working...thanks – Nabin Samanta Nov 14 '18 at 13:06
Welcome @NabinSamanta. So please accept answer. – Sachin Shah Nov 14 '18 at 13:14
i allready voted but its says that " Thanks for feedback. Vote cast by those with less than 15 reputation are recorded" – Nabin Samanta Nov 14 '18 at 13:25
@NabinSamanta I'm telling accept the answer. Click on right icon. Then it will convert into green icon. :) – Sachin Shah Nov 14 '18 at 13:28
ok i understood – Nabin Samanta Nov 14 '18 at 13:31
Thanks :) Happy coding ... – Sachin Shah Nov 14 '18 at 13:33

how to use variable as a field value in mongodb query?

3 Answers3