Mongodb aggregate two collection

Working with Data
7

Hi,

Sorry for the late answer.
here the document

1- the first document audience:

{
		"id":"5234",
		"name":"Simulation SDB",
		"createdDate":"",
		"updatedDate":"",
		"numberOfBurn":"",
		"offerValidityDays":"",
		"category":""
},
{
		"id":"2334",
		"name":"Cusine renovation",
		"createdDate":"",
		"updatedDate":"",
		"numberOfBurn":"",
		"offerValidityDays":"",
		"category":""
}

2- the second document

{
	id:1233,
	audienceId: 5234,
	entryDate:"2022/12/02",
	updateDate": "2022/12/02",
	burnRemaining": "3",
	dateOfLastBurn": "2022/12/02" 
},
{
	id:234,
	audienceId: 2334,
	entryDate:"2022/12/02",
	updateDate": "2022/12/02",
	burnRemaining": "3",
	dateOfLastBurn": "2022/12/02" 
},
{
	id:234,
	audienceId: 5234,
	entryDate:"2022/12/02",
	updateDate": "2022/12/02",
	burnRemaining": "3",
	dateOfLastBurn": "2022/12/02" 
}

3- I would like to get this document by pipeline aggregate

{
  id:"1233",
  buCode:"LMFR",
  audiences[
	{
	  audience:{
		id:"5234",
		name:"Simulation SDB",
		createdDate:"",
		updatedDate:"",
		numberOfBurn:"",
		offerValidityDays:"",
		category:""
	  },
	  createdDate:"",
	  updateDate: "",
	  burnRemaining: "",
	  dateOfLastBurn: "" 
	},
	  audiences[
	{
	  audience:{
		id:"2334",
		name:"Cusine renovation",
		createdDate:"",
		updatedDate:"",
		numberOfBurn:"",
		offerValidityDays:"",
		category:"LOYALTY"
	  },
	  createdDate:"",
	  updateDate: "",
	  burnRemaining: "",
	  dateOfLastBurn: "" 
	}
	]
},
{
  id:"1233",
  buCode:"LMFR",
  audiences[
	{
	  audience:{
		id:"5234",
		name:"Simulation SDB",
		createdDate:"",
		updatedDate:"",
		numberOfBurn:"",
		offerValidityDays:"",
		category:""
	  },
	  createdDate:"",
	  updateDate: "",
	  burnRemaining: "",
	  dateOfLastBurn: "" 
	}
	]
}

Thanks