In my project, I have a user and item collection. I have maintained the active_status of users. I want to get active users' items using user and item collection.
Item Collection
const item_model =new mongoose.Schema({
user_id:{
type: mongoose.Schema.Types.ObjectId,
ref: user,
require: true,
},
category: {
type: String,
require: true,
},
name: {
type: String,
require: true,
},
price: {
type: Number,
require: true,
},
stock: {
type: Number,
require: true,
}
}
User Collection
var user = new Schema({
firstName:{
type: String,
require: true
},
lastName:{
type: String,
require: true
},
email:{
type: String,
require: true
},
password:{
type: String,
require: true
},
user_status:{
type: String,
require: true,
default: 1
}
}
can I join these two tables and get active users items?