gistfile1.txt

db.matrix_parameter_row__c.find({
    "$or": [
        {
            "NE__Active__c": true,
            "Row_Type__c": {
                "$in": [
                    "Tariff",
                    "Metering",
                    "Discount"
                ]
            },
            "PMS_OID__c": "2",
            "PMS_zipcode__c": "01069",
            "NE__Start_Date__c": {
                "$lte": "2022-01-27T00:00:00.000Z"
            },
            "NE__End_Date__c": {
                "$gte": "2022-01-27T00:00:00.000Z"
            },
            "PMS_metertype__c": {
                "$in": [
                    null,
                    "",
                    "kME"
                ]
            },
            "PMS_main_grid__c": true,
            "Start_From__c": {
                "$lte": "1200"
            },
            "Up_To__c": {
                "$gte": "1200"
            },
            "Tariff_Type__c": "Electricity"
        },
        {
            "NE__Active__c": true,
            "Row_Type__c": "Bonus",
            "PMS_OID__c": "2",
            "PMS_zipcode__c": "01069",
            "NE__Start_Date__c": {
                "$lte": "2022-01-27T00:00:00.000Z"
            },
            "NE__End_Date__c": {
                "$gte": "2022-01-27T00:00:00.000Z"
            },
            "PMS_sales_channel__c": "Telesales",
            "PMS_Product_Assignment_ID__c": {
                "$in": [
                    null,
                    "",
                    "EON PMS Optimalstrom Basic_EON PMS Optimalstrom Oeko_EON PMS OptimalStrom Oeko 24"
                ]
            },
            "Start_From__c": {
                "$lte": "1200"
            },
            "Up_To__c": {
                "$gte": "1200"
            },
            "Tariff_Type__c": "Electricity"
        },
        {
            "NE__Active__c": true,
            "Row_Type__c": "Premium",
            "NE__Start_Date__c": {
                "$lte": "2022-01-27T00:00:00.000Z"
            },
            "NE__End_Date__c": {
                "$gte": "2022-01-27T00:00:00.000Z"
            }
        },
        {
            "NE__Active__c": true,
            "Row_Type__c": "ProductAssignment",
            "NE__Start_Date__c": {
                "$lte": "2022-01-27T00:00:00.000Z"
            },
            "NE__End_Date__c": {
                "$gte": "2022-01-27T00:00:00.000Z"
            },
            "PMS_Product_Assignment_ID__c": "EON PMS Optimalstrom Basic_EON PMS Optimalstrom Oeko_EON PMS OptimalStrom Oeko 24"
        }
    ]
})