I have a custom model defined as follows:
var MessageSchema = new Schema({
msgID: String,
patientList: [String],
created_at: Date,
updated_at: Date
});
The patientList is always dynamic in nature.
I am attempting to construct a Mongoose query that can retrieve all records where a specific patientID is present within the patientList of a given message. However, my current implementation returns empty results.
var patientID = req.params.patientID;
var query = Message.find({});
if(patientID){
console.log(patientID);
query = query.where(patientID).in('patientList');
}
All the existing queries I've come across are aimed at searching within an array with fixed values. In my scenario, the patientList may contain any number of patientIDs.
Any suggestions or solutions would be greatly appreciated.
At present, the output generated is:
{
"name": "MongoError"
}