This is my MongoDB sample collection. I want to apply a filter and want only below columns in resultset(I am using mongoexport in powershell)
Filter: Details.ResponseDetails.ResponseInformation.MasterRequestNumber = "1000001"
Result Columns: RequestNumber, MasterRequestNumber, CustomerName, Comments
`{
"_id": ObjectId("0000000000000001"),
"RequestNumber": "5000001",
"CreatedTS": ISODate("2022-09-01T00:00:00.000+0000"),
"Details": {
"ResponseDetails": {
"ResponseInformation": {
"MasterRequestNumber": "1000001",
"RequestType": "S",
"LastActionDate": ISODate("2022-09-05T00:00:00.000+0000"),
"CustomerName": "Customer-1"
},
"TransInfo": "Transaction information sample - 1"
},
"Comments": "Test Message - 1"
}
}
{
"_id": ObjectId("0000000000000002"),
"RequestNumber": "5000002",
"CreatedTS": ISODate("2022-09-02T00:00:00.000+0000"),
"Details": {
"ResponseDetails": {
"ResponseInformation": {
"MasterRequestNumber": "1000001",
"RequestType": "E",
"LastActionDate": ISODate("2022-09-05T00:00:00.000+0000"),
"CustomerName": "Customer-2"
},
"TransInfo": "Transaction information sample - 2"
},
"Comments": "Test Message - 2"
}
}`