How to find a record in MongoDB using Node.js

Question

I am trying to find whether my collection has a record with profilename = john and if exists I return status success if else I return fail but in my case, it is returning success for both cases.I am new to node and mongo can any one help me.

My function,

    exports.searchprofilename = function (req, res) {
  var params = req.params;console.log(req.params.id);
  var record= db.collection('profile');
   record.find({profilename:params.id}, (err, result) => {
   if (err){ return console.log(err)
    }
      if(!result){
            data = {status:'success'};
        } else{
             data = {status:'profile name already exists'};
        }
      res.send(data);
  });
};

Anusha Dharmasena · Accepted Answer · 2016-09-19 05:40:12Z

1

If you are only checking if a record exists, you should be easily able to do it using db.collection.count() method and checking if the number of records = 0 or not.

https://docs.mongodb.com/manual/reference/method/db.collection.count/

Honestly, I am way new to mongodb and I still cannot grasp the idea of cursors which is the return type of db.collection.find() as per https://docs.mongodb.com/manual/reference/method/db.collection.find/

answered Sep 19, 2016 at 5:40

Anusha Dharmasena

1,27714 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Buddy · Accepted Answer · 2016-09-19 06:08:48Z

1

I cleared it by changing find({}) to findOne({}),Thank you every one.

edited Sep 19, 2016 at 6:08

Buddy

11k5 gold badges47 silver badges63 bronze badges

answered Sep 19, 2016 at 6:04

klp

1531 gold badge3 silver badges15 bronze badges

Comments

abdulbari · Accepted Answer · 2016-09-19 05:21:51Z

0

If your query matches then it means you have record then return Success

 exports.searchprofilename = function (req, res) {
  var params = req.params;console.log(req.params.id);
  var record= db.collection('profile');
   record.find({profilename:params.id}, (err, result) => {
   if (err){ return console.log(err)
    }
    // If record exist then return 'Success'
      if(result.length>0){
            data = {status:'success'};
        } else{
             data = {status:'profile name already exists'};
        }
      res.send(data);
  });
};

answered Sep 19, 2016 at 5:21

abdulbari

6,2625 gold badges41 silver badges65 bronze badges

1 Comment

Anusha Dharmasena Over a year ago

That's what I thought too. But the documentation wasn't very clear about properties of Cursors. Thanks for explaining.

王如锵 · Accepted Answer · 2016-09-19 06:01:28Z

0

I think in your case, req.params.id is a String for example '123', but in your mongodb profilename field is stored as an Number.

So you can try this:

change {profilename:params.id} to {profilename:parseInt(params.id)}

answered Sep 19, 2016 at 6:01

王如锵

9911 gold badge7 silver badges18 bronze badges

Comments

Wasiq Muhammad · Accepted Answer · 2016-09-19 12:48:08Z

0

Try this

    exports.searchprofilename = function (req, res) {
        console.log("PARAMS",req.params.id);
        var data = {};
        profile.findOne( {profilename:req.params.id} , function (err, fetchDataObj) {
                if (err) {
                    console.log(err)
                   return err;
                } else {
                    data.status = 'success';
                    data.result = fetchDataObj;
                    return data;
                }
            }).lean(true)

  });

edited Sep 19, 2016 at 12:48

answered Sep 19, 2016 at 5:24

Wasiq Muhammad

3,1483 gold badges19 silver badges30 bronze badges

1 Comment

Wasiq Muhammad Over a year ago

@downvoter please identify whats wrong in the answer??

PinHead877 · Accepted Answer · 2016-09-19 05:18:41Z

-1

Try to Debug. the type of result is array, so try to check the length of it:

if(result.length==0){
    data = {status:'success'};
} else{
    data = {status:'profile name already exists'};
}

answered Sep 19, 2016 at 5:18

PinHead877

636 bronze badges

Collectives™ on Stack Overflow

How to find a record in MongoDB using Node.js

6 Answers 6

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related