Mongoose get multiple collection data using query

Question

I am trying to join two mongoose collection and fetch all related details using the query which i have mention below. Problem is I am getting only one table details employee collection not able get two collection detail when I call GetEmployeeDetails(emp_id) . Need a suggestion. How to get two collection data in one query.

const EmployeeInfoSchema = mongoose.Schema({
  employee_id: String,
  client_id: {
    type: Schema.Types.Number,
    ref: "client",
  },
  email: String,
  contact: String,
});

const ClientInfoSchema = mongoose.Schema({
  client_id: Number,
  employee_id: {
    type: Schema.Types.String,
    ref: "employee",
  },
  project: String,
  organization: String,
});

let employeeInfo = mongoose.model("employee", EmployeeInfoSchema);
let clientInfo = mongoose.model("client", ClientInfoSchema);

module.exports = { employeeInfo, clientInfo };

Query

async function GetEmployeeDetails(emp_id) {
  let employee_info = await Storage.employeeInfo
    .find()
    .where({ employee_id: emp_id })
    .populate({
      path: "client",
    })
    .exec(function (err, block) {
      if (err) {
        console.log("%s", err);
      }
      console.log("Employee details is %s", employee_info);
    });

  return employee_info;
}

lpizzinidev · Accepted Answer · 2022-05-04 12:41:38Z

1

Try to change your GetEmployeeDetails method like this:

async function GetEmployeeDetails(emp_id) {
  try {
    let employee_info = await Storage.employeeInfo
      .find({ employee_id: emp_id })
      .populate('client')
      .exec(function (err, block) {
        if (err) console.log('%s', err);
        else console.log('Employee details is %s', employee_info);
      });

    return employee_info;
  } catch (err) {
    res.status(400).send('Error getting details');
  }
}

answered May 4, 2022 at 12:41

lpizzinidev

13.3k2 gold badges15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongoose get multiple collection data using query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related