MongoDB get Value of a Field in NodeJS

Question

I'm new to MongoDB and I try to create a User Coin System for discord with NodeJS. There is no problem in adding new documents to the collection but i can not access only a single value. I want to return the value of "coins" to let the user see his coins. I'm using the find() method and it returns a document:

    {
    "_id": {
        "$oid": "5f875963b622f72c3850da6f"
    },
    "username": "Test",
    "userID": "1234",
    "messages": {
        "$numberInt": "22"
    },
    "coins": {
        "$numberInt": "210"
    },
    "__v": {
        "$numberInt": "0"
    }
}

I tried to access "coins" with dot but it always returns undefined:

User.find({userID: message.author.id}).exec((err, res) => {
  if (err) return console.log(err);

  let embed = new Discord.RichEmbed()
    .setTitle(message.author.tag)
    .setColor("#4000FF")
    .setThumbnail(message.author.displayUserAvatarURL);
//User has no Coins
    if(!res){
      embed.addField("Coins", "0", true);
      return message.reply(embed);
    }else {
//res.coins are undefined. Returning 'res' is the whole document from above.
      embed.addField("Coins", res.coins , true);
      return message.reply(embed);
    }
})

Mongoose .find() must be giving you results in an array[] even though it contains only one document. You might want to try accessing the value via index: res[0]['coins'] etc. — ambianBeing
– ambianBeing, Commented Apr 4, 2020 at 15:31

Shohanur · Accepted Answer · 2020-04-04 15:06:15Z

2

     1. Try using findOne 
2. check  your userId  in db is string format so it could be a problem .
3. Convert your  message.author.id to string before finding. then you will find everything in your result object


    let user_id=message.author.id;
        User.findOne({userID: user_id.toString()},function(error, body) {
                                   if (error){
                                    result(error, null);
                                   }
         var  results= body;

        })

answered Apr 4, 2020 at 15:06

Shohanur

1267 bronze badges

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

Collectives™ on Stack Overflow

MongoDB get Value of a Field in NodeJS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related