How to fix mongoose query that returns empty array

Question

I am trying to query for records in my database but I am getting an empty array. I don't know what I am doing wrong? I have a feeling the issue could be my schema, here it is:

my schema

const QuizSchema = new Schema({

    question: {
        type:String,
        default:''
    },
    answers: [{
        type: {
            type: String,
            default:''
        },
        content: {
            type: String,
            default:''
        },
    }]
});

module.exports=Quiz=mongoose.model('quizes',QuizSchema,'quiz');

Here is the mongoose query

const Quiz = require('../../models/Quiz');

router.get('/',(req,res)=>{

Quiz.find({},null)
.then(data=>res.json(data))
.catch(err=>console.log(err))
});
module.exports = router;

And here is a sample JSON data

{
        "question": "What is a Mongoose ? ",
        "answers": [
            { "type": "Smart","content": "Animal" }, {"type": "Subpar", "content": "Software"}, { "type": "Confused", "content": "Poem" }]

    }

Would appreciate your assistance. Thanks in advance!

@Shubh Yes, i have tried without parameters, same empty array — 8SINS
– 8SINS, Commented Sep 12, 2019 at 10:35

tbking · Accepted Answer · 2019-09-12 10:33:41Z

1

<query>.then doesn't return the data. You should use <query>.exec().then to access the data returned by the query. So change your code to something like:

Quiz.find({},null)
.exec()
.then(data=>res.json(data))
.catch(err=>console.log(err))
});
module.exports = router;

Source: Mongoose docs

answered Sep 12, 2019 at 10:33

tbking

9,1462 gold badges23 silver badges33 bronze badges

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

3 Comments

tbking Over a year ago

@8SINS please add the logged response and the query you are using fetch the sample data.

8SINS Over a year ago

router.get('/',(req,res)=>{ Quiz.find({},null) .exec() .then(data=>res.json(data)) .catch(err=>console.log(err)) }); I am testing with postman, and the reponse is 200 oK but with an empty array

8SINS Over a year ago

Your Solution was correct! I just found out my mistake... I wasn't querying the right DB. thanks a lot

Binod Chaudhary · Accepted Answer · 2019-09-12 11:33:13Z

0

Modify Schema like this: Inside the array, field name like 'type' is not accepted.

const QuizSchema = new Schema({

    question: {
        type:String,
        default:''
    },
    answers: [{
        ans_type: { // CHANGE HERE
            type: String,
            default:''
        },
        content: {
            type: String,
            default:''
        },
    }]
});

module.exports=Quiz=mongoose.model('quizes',QuizSchema,'quiz');

answered Sep 12, 2019 at 11:33

Binod Chaudhary

174 bronze badges

Collectives™ on Stack Overflow

How to fix mongoose query that returns empty array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related