How to use where to query the database using mongoose

Question

I want to create an endpoint for the user to search for something, so im querying the database using where a particular row inlcudes the text the user has searched but $where keeps giving me an error that it is not a function

I have tried using the $where but to no avail

router.get('/mobile/courses/search/:search_text', async(req, res)=>{
    try {
        const search = await Course.find()
        search.$where(function () {
            return req.params.search_text.toLowerCase().includes(this.course_name.toLowerCase())
        })
        if (!search){
            return res.status(404).send({result: 'No Result found'})
        }

        res.status(200).send({result: search})
    }catch (e) {
        res.status(500).send({error: 'Unknown Error Occurred Try Again', codeerror: e.toString()})
    }
})

I want to be able to query the database for what the user has searched from a particular column (course_name) and return a response of the rows containing that at least three letters from the text the user searched

i think you miss some basic knowledge about MongoDB. It is not a RDBMS and the concept of columns does not exists. — marcopiii
– marcopiii, Commented May 29, 2019 at 9:21

Thamaraiselvam · Accepted Answer · 2019-05-29 09:15:11Z

2

First index the field that you want to search

Course.index({ course_name: 'text' });

Then use $regex

CourseModal
    .find({
        course_name: {
            $regex: searchString,
            $options: 'i'
        }
    })

answered May 29, 2019 at 9:15

Thamaraiselvam

7,1128 gold badges51 silver badges73 bronze badges

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

Comments

ganjim · Accepted Answer · 2019-05-29 09:24:52Z

1

You can directly use mongoDB $regex option in query to search your text:

router.get('/mobile/courses/search/:search_text', async(req, res)=>{
    try {
        const searchedItems = await Course.find({
            course_name: { 
                $regex: req.params.search_text,
                $options: 'i' // case insensitive
            } 
        })
        if (!searchedItems.length){
            return res.status(404).send({result: 'No Result found'})
        }
        res.status(200).send({result: searchedItems})
    }catch (e) {
        res.status(500).send({error: 'Unknown Error Occurred Try Again', codeerror: e.toString()})
    }
})

answered May 29, 2019 at 9:24

ganjim

1,4261 gold badge21 silver badges35 bronze badges

1 Comment

Emmanuel Okocha Over a year ago

Thanks this helped

Collectives™ on Stack Overflow

How to use where to query the database using mongoose

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related