Db.find get null

Question

We are trying to figure out how get the data from the database but the result get "null"

the model

const mongoose = require("mongoose");

const ClubSchema = new mongoose.Schema({
  nomClub: String,
  classement: String,
  dateMatch: String,
  classementDB: String,
  logo: String,
  adversaire: String,
});
const SportSchema = new mongoose.Schema({
  nom: String,
  clubs: [ClubSchema],
});
module.exports = mongoose.model("sport", SportSchema);

and the back

getSportAdversaire: (req, res) => {
    Sport.findOne({ "clubs.nomClub": "Stade Rennais" }, (err, data) => {
      if (err) {
        console.log(err);
        res.json({ message: "une erreur s'est produite" });
      } else {
        res.json(data);
        console.log(data);
      }
    });
  },

Nitheesh · Accepted Answer · 2020-08-31 15:57:15Z

1

You dont need to use the key as clubs.nomClub. You can simply use the key as nomClub. Your key name is nomClub and not clubs.nomClub.

sport.findOne({ "nomClub": "Stade Rennais" }, (err, data) => {
  if (err) {
    console.log(err);
    res.json({ message: "une erreur s'est produite" });
  } else {
    res.json(data);
    console.log(data);
  }
});

edited Aug 31, 2020 at 15:57

answered Aug 31, 2020 at 11:12

Nitheesh

20.1k3 gold badges28 silver badges52 bronze badges

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

2 Comments

Wendy Montagnon Over a year ago

Same problem, same answer "null" :(

Nitheesh Over a year ago

@Wendy it seems that there is a typo in your Collection name. The first letter S is small cased in defenition where as capital cased while finding from the collection

Collectives™ on Stack Overflow

Db.find get null

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related