Hi Experts, I am new to MongoDB.
I need help to query and project nested documents.
Consider the following sample documents of a collection, CPU load is a nested document its field names vary in different records.
{
"time": ISODate("2022-08-12T11:05:00Z"),
"nodeName": "selipcnsgsnmme174",
"cpuload": {
"1_11(FSB)": 0.04,
"1_15(NCB)": 0.04,
"1_9(NCB)": 0.01,
"2_1(AP/LC/SS7_SCTP_DP)": 0.13,
"2_2(AP/LC/SS7_SCTP_DP)": 0.12,
"2_1(LC)": 0,
"2_2(LC)": 0
}
}
{
"time": ISODate("2022-08-12T11:10:00Z"),
"nodeName": "selipcnsgsnmme174",
"cpuload": {
"1_11(FSB)": 0.04,
"1_15(NCB)": 0.04,
"1_9(NCB)": 0,
"2_1(AP/LC/SS7_SCTP_DP)": 0.13,
"2_2(AP/LC/SS7_SCTP_DP)": 0.12,
"2_1(LC)": 0.01,
"2_2(LC)": 0
}
}
I would like to project is like the following:
{
"time": ISODate("2022-08-12T11:05:00Z"),
"nodeName": "NODE2",
"2_11(FSB)": 0.04,
"2_15(NCB)": 0.04,
"2_9(NCB)": 0.01,
"2_1(AP/LC/SS7_SCTP_DP)": 0.13,
"2_2(AP/LC/SS7_SCTP_DP)": 0.12,
"2_1(LC)": 0,
"2_2(LC)": 0
}
{
"time": ISODate("2022-08-12T11:10:00Z"),
"nodeName": "NODE1",
"_11(FSB)": 0.04,
"1_15(NCB)": 0.04,
"1_9(NCB)": 0,
"1_1(AP/LC/SS7_SCTP_DP)": 0.13,
"1_2(AP/LC/SS7_SCTP_DP)": 0.12,
"1_1(LC)": 0.01,
"1_2(LC)": 0
}