Myujth

Below is my code to query search by city. I am getting not found in my post> I need to be able to search for a specific city and get all the records for the field that matches the city. For example, if city is Downtown, I want all the records with the city downtown

 router.get("/search", (req, res, next) =>
 const city = req.query.city;
 Facility.findAll(city)
 .select('name type mobile price streetName city state _id')
 .exec()
 .then(docs => 
 console.log("From database", docs);
 if (docs) 
 res.status(200).json(
 facility: docs
 );
 else 
 res
 .status(404)
 .json( message: "No valid entry found for provided City" );
 
 )
 .catch(err => 
 console.log(err);
 res.status(500).json( error: err );
 );

 );

Here is a better way to do it;

router.get('/search', (req, res) => 
 const city = req.query
 Facility.find(city)
 .select('name type mobile price streetName city state')
 .exec((err, doc) => 
 if (err) 
 return res.status(500)
 .json( message: 'error querying cities', error: err );
 
 if (!docs) 
 return res.status(404)
 .json( message: 'No valid entry found for provided City' );
 
 return res.status(200)
 .json(
 facility: docs
 );
 )
)

find() will do the job. I don't see a need for you to select _id, you only specify with -_id if you don't want it but _id is selected by default.

Below is a list of valid queries in Mongoose if that is what you're using

Model.deleteMany()
Model.deleteOne()
Model.find()
Model.findById()
Model.findByIdAndDelete()
Model.findByIdAndRemove()
Model.findByIdAndUpdate()
Model.findOne()
Model.findOneAndDelete()
Model.findOneAndRemove()
Model.findOneAndUpdate()
Model.replaceOne()
Model.updateMany()
Model.updateOne()

Check https://mongoosejs.com/docs/queries.html for more information on queries

I hope this helps

You're almost there. Just specify your query and you should be fine

https://mongoosejs.com/docs/api.html#model_Model.find

router.get("/search", (req, res, next) =>
 const city = req.query.city;
 Facility.findAll(propertyName: city)
 .select('name type mobile price streetName city state _id')
 .exec()
 .then(docs => 
 console.log("From database", docs);
 if (docs) 
 res.status(200).json(
 facility: docs
 );
 else 
 res
 .status(404)
 .json( message: "No valid entry found for provided City" );
 
 )
 .catch(err => 
 console.log(err);
 res.status(500).json( error: err );
 );

 );

Below is the working code:

router.get('/search', (req, res) => 
const city = req.query.city
 Facility.find(city)
 .select('name type mobile price streetName city state')
 .exec((err, docs) => 
 if (err) 
 return res.status(500)
 .json( message: 'error querying cities', error: err );
 
 if (!docs) 
 return res.status(404)
 .json( message: 'No valid entry found for provided City' );
 
 return res.status(200)
 .json(
 count: docs.length,
 facility: docs
 );
 )

);