Mongoose query a populated field

mongoose populate
Thijs Koerselman picture Thijs Koerselman · Jul 8, 2013 · Viewed 13.2k times · Source 
   db.History.find({'_file.project': 'someproject' )
      .populate('_file', 'name reference project')
      .sort(sortField || '-created')
      .limit(max || 64)
      .exec(this);

Here I'm trying to find all documents which match on a populated field from the _file reference. Is doesn't seem to work. Is something like this possible at all?

I could duplicate the project field to this object, as a workaround just for querying but I'd rather not of course.

Answer

JohnnyHK picture JohnnyHK · Jul 8, 2013

No, a find query's conditions parameter can only reference the collection being queried.

populate is not a join, it's just a convenience function to follow up the main query with additional queries to pull in the associated data from other collections.

Related questions

Mongoose: deep population (populate a populated field)

I have Category model: Category: ... articles: [{type:ObjectId, ref:'Article'}] Article model contains ref to Account model. Article: ... account: {type:ObjectId, ref:'Account'} So, with populated articles Category model will be: { //category articles: //this field is populated [ { account: 52386c14fbb3…

Read More
Mongoose populate after save

I cannot manually or automatically populate the creator field on a newly saved object ... the only way I can find is to re-query for the objects I already have which I would hate to do. This is the setup: var …

Read More
Mongoose: Cast to ObjectId failed for value

I'm trying to specify the schema of my db in mongoose. At the moment I do this: var Schema = mongoose.Schema; var today = new Date(2011, 11, 12, 0, 0, 0, 0); var personSchema = new Schema({ _id : Number, name: { type: String, required: true }, tel: { type: String, required: …

Read More