the background of the project is to send data to the three-party platform. To ensure that the data can be traced back, the messages (Json format string) under the three-party platform are stored under the Message.bizData node, as shown in the following example. Now that I want to query the data of transOrderCode= 91011081818, how should I write the query statement? I tried find ({"Message.bizData.transOrderCode": "91011081818"}), but it didn"t work. Should I deserialize the message into objecjt, and then store it in bizData?
{
"_id" : ObjectId("5be28b1167cdcb184310c75e"),
"name" : "Best_mmg.Controllers.OrderController",
"type" : "request",
"datetime" : ISODate("2018-11-07T06:49:53.463Z"),
"Message" : {
"sign" : "bb3e894d17e069933f6dad7e19ced77f",
"serviceType" : "KY_INSTALL_ORDER_CREATE_NOTIFY",
"partnerID" : "SU_JIA",
"bizData" : "{
"partnerCode": "SU_JIA",
"cpCode": "BESTQJT",
"transOrderCode": "91011081818",
"acceptPerson": "",
"acceptPhone": "13560259167",
"acceptProvince": "",
"acceptCity": "",
"acceptArea": "",
"acceptAddress": "42307",
"acceptPostCode": null,
"pickupSiteCode": "5100803",
"pickupSiteName": "",
"pickupSiteProvince": "",
"pickupSiteCity": "",
"pickupSiteArea": "",
"pickupSiteAddress": "200",
"pickupSitePerson": "",
"pickupSitePhone": "13925700028",
"serviceType": "DISP_INSTALL",
"packageAmount": "4",
"packageCubic": "1.65",
"packageWeight": "330.0",
"isElevator": "false",
"floor": "0",
"salesPlatform": null,
"salesOrder": null,
"salesName": null,
"salesPhone": null,
"remark": null,
"itemList": {
"itemDetailList": [{
"itemSKU": null,
"itemCode": "01011010001",
"itemName": "",
"amount": "1",
"checkerID": null,
"checkerName": "",
"checkCode": "246438497499365546",
"remark": null,
"imgUrl": null
}
]
},
"addServiceList": {
"addServiceDetailList": [
]
}
}"
}
}