Multiple collection join/concat query with Mongoose similar to union query in SQL

Question

I have 4 collection named students, teachers, stuffs and managers with same mongoose schema.

const schema = new Schema({
    name: String,
    age: Number,
    email: String
})

how can I retrieve all the students, stuffs, managers and teachers where their age>=25 within one query? data should be look like concatenated as in SQL performs in union query.

user_14732669 · Answer

You can use $unionWith. Specify the age >= 25 criteria in pipeline.

Here is the Mongo Playground for your reference.

Multiple collection join/concat query with Mongoose similar to union query in SQL

1 Answers