Search and filter data in Mongo DB using mongoose

Question

var questionSchema = new Schema({
    category: { name:
        {
        type: String,
        lowercase: true,
        required: [true, 'Category is a required field']
    },
        question:[
            {
                q: {
                    type: String,
                    lowercase: true
                    
                },
                options: {
                    option1:{
                        type: String,
                        lowercase: true
                        
                    },
                    option2:{
                        type: String,
                        lowercase: true
                       ]
                    },
                    option3:{
                        type: String,
                        lowercase: true
                        
                    },
                    option4:{
                        type: String,
                        lowercase: true
                        
                    },
                },
                ans: {
                    type: String,
                    lowercase: true
                  
                },
                level:{
                    type: String,
                    lowercase: true
               
                }

            }

        ]
    },


},
    {
        strict: true,
        runSettersOnQuery: true,
        timestamps: {
            createdAt: 'created', updatedAt: 'updated'
        }
    });

This is my question schema. I am trying to get all the questions of a particular category. Till now I have tried this ---

function (req,res,next) {
    console.log(req.params.qcategory);
    Question.find({
        category:{
            name: req.params.qcategory,
        }
    },'', function (err,data) {
        if (err) {
            err.status = 406;
            return next(err);
        }
        console.log(data);
        return res.status(201).json({
            message: ' success.',data:data
        })
    })
};

In req.params.qcategory it contains the name of the category like 'programming' for instance. But it returned me an empty array. **PS. There are questions of programming category in my DB. Then What am i doing wrong ???

Also is there a way to first check what category a question is and then add to the question array inside that particular category. I don't want to add questions with categories again and again instead i want to check if that category already exists in the database and push the question inside the array of that question category. For instance if a question is of 'programming' category and in the database there is already a question which is of again a 'programming' category then push the question inside the array of programming category.

If my questions are not clear then please comment I will respond quickly.

Thank you nidhin but what if a category doesn't exist then this method wont work right ? — iAmRoot, Sep 30 '17 at 08:01
`{upsert:true}` option? https://stackoverflow.com/a/25116688/3359432 Also make sure data you query exists in DB. Maybe because of schema data won't be there. — Nidhin David, Sep 30 '17 at 08:02
Have you tried using [dot notation](https://docs.mongodb.com/manual/core/document/#embedded-documents) as `Question.find({ 'category.name': req.params.qcategory }, function (err, data) { ... });`? — chridam, Sep 30 '17 at 09:31
Why are you passing an empty string after query object and before callback in `find()`? — Nidhin David, Sep 30 '17 at 16:06

Kayslay · Accepted Answer · 2017-10-01T11:43:33.267

Try this, Not tested

function (req,res,next) {
console.log(req.params.qcategory);
Question.find({
    "category.name": req.params.qcategory,}
 , function (err,data) {
    if (err) {
        err.status = 406;
        return next(err);
    }
    console.log(data);
    return res.status(201).json({
        message: ' success.',data:data
    })
})
};

Replace the {category:{name:req.params.qcategory}} with {"category.name":req.params.qcategory}.

read more on mongodb's Query Embedded Documents https://docs.mongodb.com/.../method/db.collection.find/

score 0 · Answer 2 · edited Dec 07 '20 at 20:24

0

Try this.

function (req,res,next) {
    console.log(req.params.qcategory);
    const name = req.params.qcategory;
    Question.find({name})
        .then((data)=>return res.status(201).json({message:"success",data:data})
        .catch(err=> {
            res.status(406)
            return next(err);
        })
};

edited Dec 07 '20 at 20:24

Joundill

6,828
12
36
50

answered Dec 07 '20 at 18:44

Kuntu

1
2

Search and filter data in Mongo DB using mongoose

2 Answers2