MongoDB User.findOne({email:email})

Question

findOne return null Always

I have "user(hello@gmail.com)" data in the database but User.findOne returns null always. Please Help me. I have a node running on background but it gives me null . req.body gives the email that im passing but findOne isnot working. User.create is working fine. but search queries like find,findById,findOne is not working. SomeOne please help me.

const userSchema = new mongoose.Schema({
 name: {
    type: String,
    required: [true, 'A user must have a unique name'],
    unique: true,
  },
  password: {
    type: String,
    required: true,
    unique: true,
    minlength: 8,
  },
  email: {
    type: String,
    required: [true, 'A user must have a unique name'],
    unique: true,
    lowercase: true,
  }
const User = mongoose.model("User", userSchema);

exports.getTest=async (req,res)=>{
    const {email} = req.body  // returns "hello@gmail.com"
    const user = await User.findOne({email})
    console.log(user) //returns null
    res.json({
     
        status:"success",
        data:{
            user
        }
    })

}

You probably have a space or mismatch in your email field. Your syntax looks correct and you do not need exec(). Triple check all assumptions as these are the root of all evil. — King Friday, Apr 20 '21 at 14:04
I was told `.exec()` made Mongoose requests asynchronous, I could never check if this was true — Jeremy Thille, Apr 20 '21 at 14:07
this is my second week trying to find my bug. i couldnot find.thats why i need your help guys — Charan Chintapalli, Apr 20 '21 at 14:10

score 0 · Answer 1 · answered Apr 20 '21 at 15:42

I have a feeling your issue lies in the first two lines of your test?

const {email} = req.body  // returns "hello@gmail.com"
const user = await User.findOne({email})

If your req.body just returns the email string, then maybe your query isn't in the right JSON format?

Are you sure that the query actually ends up being User.findOne({email: "hello@gmail.com"}) instead of just User.findOne("hello@gmail.com")?

Also not sure if you need exec() at the end, but it does execute the query and return a Promise...

```User.findOne({email: "hello@gmail.com"})``` yes sir .it takes like that i checked million times. the queries is not working i dont know why — Charan Chintapalli, Apr 21 '21 at 03:33

score 0 · Accepted Answer · answered May 03 '21 at 14:19

0

Documents should save active: true in the database. but instead, I'm saving every document as false as the default value. So, this is my answer if anyone in the future finds it useful let me know. Take care and goodbye

answered May 03 '21 at 14:19

Charan Chintapalli

11
5

MongoDB User.findOne({email:email})

2 Answers2