How to Join Two table using MongoDB + Node.js API?

Question

I am new for node.js and mongodb created api using help of google

Created Api using monogdb + nodejs.

Working fine with single table CURD operation

But don't know how to join in node.js

request.model.js

const mongoose = require('mongoose');

const RequestSchema = mongoose.Schema({
    userId: String,
    title: String,
    description: String
}, {
    timestamps: true
});

module.exports = mongoose.model('Request', RequestSchema);

user.model.js

const mongoose = require('mongoose');

const UserSchema = mongoose.Schema({
    firstname: String,
    lastname: String
}, {
    timestamps: true
});

module.exports = mongoose.model('User', UserSchema);

user.controller.js

const User = require('../models/user.model.js');

// Retrieve and return all notes from the database.
exports.findAll = (req, res) => {
  jwt.verify(req.token, 'secretkey', (err, authData) => {
    if(err){
      res.sendStatus(403);
    }else{
      User.find()
      .then(user => {
        res.send(user);
      }).catch(err => {
        res.status(500).send({
          message: err.message || "Some error occurred while retrieving user."
        });
      });
    }
  })
};

request.controller.js

const Request = require('../models/request.model.js');

// Retrieve and return all notes from the database.
exports.findAll = (req, res) => {
  jwt.verify(req.token, 'secretkey', (err, authData) => {
    if(err){
      res.sendStatus(403);
    }else{
      Request.find()
      .then(request => {
        res.send(request);
      }).catch(err => {
        res.status(500).send({
          message: err.message || "Some error occurred while retrieving request."
        });
      });
    }
  })
};

request table data structure

{
    "_id": {
        "$oid": "5e3bef0be7b75760bf31d4c8"
    },
    "userId": "5e3bdf5919c9d8586d7f2455",
    "title": "test title",
    "description": "test desc",
    "createdAt": {
        "$date": {
            "$numberLong": "1580986123184"
        }
    },
    "updatedAt": {
        "$date": {
            "$numberLong": "1580986123184"
        }
    },
    "__v": {
        "$numberInt": "0"
    }
}

user table data structure

{
    "_id": {
        "$oid": "5e3bdf5919c9d8586d7f2455"
    },
    "firstname": "bhavik",
    "lastname": "gajjar",
    "createdAt": {
        "$date": {
            "$numberLong": "1580982105830"
        }
    },
    "updatedAt": {
        "$date": {
            "$numberLong": "1580982105830"
        }
    },
    "__v": {
        "$numberInt": "0"
    }
}

Thanks in advance

Please tell response data

Mahesh Bhatnagar
– Mahesh Bhatnagar

2020-02-06 11:33:07 +00:00
Commented Feb 6, 2020 at 11:33 — Mahesh Bhatnagar
– Mahesh Bhatnagar, Commented Feb 6, 2020 at 11:33

Łukasz Karczewski · Accepted Answer · 2020-02-06 11:22:10Z

2

If you want to query for Requests with joined users, do this:

Request.aggregate([
   {
     $lookup: {
        from: "Users", // collection name in db
        localField: "userId",
        foreignField: "_id",
        as: "user"
     }
   }
])

answered Feb 6, 2020 at 11:22

Łukasz Karczewski

1,20811 silver badges14 bronze badges

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

1 Comment

Łukasz Karczewski Over a year ago

Just replace this fragment Request.find() in request.controller.js with my code.

Collectives™ on Stack Overflow

How to Join Two table using MongoDB + Node.js API?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related