I get a null value from a mongoDB document (object is not null)

Site Feedback
1

I can’t get the values ​​from a document in mongoDB.

db.getCollection('ticket').aggregate([{$match:{switchBackup:true}},{$match:{"_id":2535}}])

result

image
image630×585 84.1 KB 

/* 1 */
{
    "_id" : 2535,
    "status" : "rejected",
    "countries" : [ 
        3, 
        5
    ],
    "switchFunctionality" : false,
    "switchDownService" : false,
    "switchLowEnvironmentTest" : false,
    "switchVersioning" : true,
    "switchSap" : false,
    "switchMonitoring" : true,
    "switchBackup" : true,
    "impactElementList" : [ 
        {
            "codigo" : "APL002",
            "nombre" : "SAP 6.0 FICO Brasil (PF5)",
            "pais" : [ 
                "Brasil"
            ],
            "unidadNegocio" : [ 
                "Adm y Finanzas"
            ],
            "key" : "APL002",
            "value" : "SAP 6.0 FICO Brasil (PF5)"
        }
    ],
    "serverList" : [],
    "operationalTowerSupport" : [ 
        16
    ],
    "implementingGroupList" : [ 
        "Workflow"
    ],
    "sapList" : [ 
        {
            "_id" : ObjectId("60a6c311bddc8f957df2116c"),
            "ot" : "",
            "description" : ""
        }
    ],
    "monitoringList" : [ 
        {
            "_id" : ObjectId("60a6c311bddc8f0c81f2116d"),
            "ip" : "1233.22.22.33",
            "description" : "blah blah"
        }
    ],
    "backupList" : [ 
        {
            "_id" : ObjectId("60a6c311bddc8fd013f2116e"),
            "ip" : "123.32.12.123",
            "element" : "4",
            "path" : "/etc",
            "date" : ISODate("2021-05-21T20:11:00.000Z"),
            "retention" : "2"
        }
    ],
    "createdAt" : ISODate("2021-05-20T20:11:47.361Z"),
    "updatedAt" : ISODate("2021-05-20T20:14:08.996Z"),
    "activityDescription" : "Descripcion test",
    "activityName" : "Titulo test",
    "changeType" : "normal",
    "ica" : "HTroncosoN",
    "impactDate" : ISODate("2021-05-21T16:16:00.000Z"),
    "impactElementToggle" : "apl",
    "selectChangeOrigin" : "1",
    "selectTimeWindow" : 2,
    "task" : "",
    "ticketNumber" : "123",
    "comment" : "Cierre automatico por Cron"
}

Result Dremio

SELECT * FROM tickets where switchBackup is true and "_id" = 2535

image
image929×196 17.9 KB

Help!

2

in the scheme there were two fields with the same name.

backupList
backuplist

Apparently, that generated confusion in Dremio, when correcting the scheme, the error is not generated.

:grinning: