'how to use compare field values in mongo compass

{
    "Employee": {
        "EmployeeData": {
        
                "basePay": "1000",
                "sumPayAmount": "2000"
            }


    }
},
{
    "Employee": {
        "EmployeeData": {
        
                "basePay": "4000",
                "sumPayAmount": "1000"
            }


    }
}

how to find the documents where basePay is greather than sumPayAmount?

mongodb


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions