Querying on a virtual property in mongoose

Question

I have a virtual property in my mongoose schema, I would like to know if I can query my documents using this property.

var PersonSchema = new Schema({   number: {type: Number, required: true},   name: {type: Date, required: true} });  PersonSchema.virtual('capitalCaseName').get(function () {   return this.name.toUpperCase(); }); ... Person.find({"capitalCaseName": "DANIEL"}).exec(); ... 

Answer 1

No, you can't. Mongoose virtual properties only exist in the Mongoose model representation of documents, not in MongoDB itself where the query is performed.

Any field you need to query against must be defined in the schema as a non-virtual field and persisted to the database.