Get result from multiple nested collection on MongoDB

Viewed 14

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"
    }
}`
0 Answers
Related