How to query the json string in Mongodb

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": [

        ]
    }
}"
    }
}
Oct.27,2021

simply put, there is no way to query. Because this is a string.
deserialization to Object allows you to query, but the query uses a full table scan, and the performance is very poor. It is very important to build relevant indexes.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3292f-2be1a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3292f-2be1a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?