This is mongodb modal
new Schema(
{
mrp: {
type: Number,
required: true
},
selling_price: {
type: Number,
required: true
},
discount_price: {
type: Number,
default: 0,
},
stock: {
type: Number,
default: 1,
required: true
},
options: [{
option: {
type: Schema.Types.ObjectId,
ref: "product-options",
},
list: {
type: Schema.Types.ObjectId,
ref: "product-variant",
}
}],
},
{
timestamps: true,
}
)
**I have these documents **
[
{
"_id":"668ce839feb678799d61998c"
"mrp": 1204,
"selling_price": 1204,
"discount_price": 100,
"stock": 100,
"options": [
{
"option":"668b9d026d5af1f1c961feae",
"list": "668ba1096d5af1f1c96203a4",
},
{
"option": "668b9cfc6d5af1f1c961fea8",
"list": "668ba1396d5af1f1c96203cd"
},
{
"option": "668b9cf16d5af1f1c961fe9a",
"list": "668ba0bf6d5af1f1c9620333",
}
],
},
{
"_id":"668d064c06cb6917fd7aaaea"
"mrp": 1000,
"selling_price": 100,
"discount_price": 90,
"stock": 20,
"options": [
{
"option": "668b9d026d5af1f1c961feae",
"list": "668ba1096d5af1f1c96203a4"
},
{
"option": "668b9cfc6d5af1f1c961fea8",
"list": "668ba1e46d5af1f1c96203ec"
},
{
"option": "668b9cf16d5af1f1c961fe9a",
"list": "668ba0bf6d5af1f1c9620333",
}
],
}
]
My input search query for options field is:-
[
{
"option":"668b9d026d5af1f1c961feae",
"list": "668ba1096d5af1f1c96203a4",
},
{
"option": "668b9cfc6d5af1f1c961fea8",
"list": "668ba1396d5af1f1c96203cd"
},
{
"option": "668b9cf16d5af1f1c961fe9a",
"list": "668ba0bf6d5af1f1c9620333",
}
]```
`My output document is:-`
{
“_id”:”668ce839feb678799d61998c”
“mrp”: 1204,
“selling_price”: 1204,
“discount_price”: 100,
“stock”: 100,
“options”: [
{
“option”:”668b9d026d5af1f1c961feae”,
“list”: “668ba1096d5af1f1c96203a4”,
},
{
“option”: “668b9cfc6d5af1f1c961fea8”,
“list”: “668ba1396d5af1f1c96203cd”
},
{
“option”: “668b9cf16d5af1f1c961fe9a”,
“list”: “668ba0bf6d5af1f1c9620333”,
}
],
}“`
New contributor
Ravi Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.