如何使用pymongo查询嵌套字段

Question

我有一个包含订单数据的JSON文件，因此每个订单都有一个如下字段（每行\u项在其列表中仅包含1个元素）：

"line_items": [
            {
                "id": 1994,
                "name": "Hoodie - Blue, No",
                "product_id": 21,
                "variation_id": 39,
                "quantity": 5,
                "tax_class": "",
                "subtotal": "225.00",
                "subtotal_tax": "0.00",
                "total": "225.00",
                "total_tax": "0.00",
                "taxes": [],
                "meta_data": [
                    {
                        "id": 14439,
                        "key": "pa_color",
                        "value": "blue",
                        "display_key": "Color",
                        "display_value": "Blue"
                    },
                    {
                        "id": 14440,
                        "key": "logo",
                        "value": "No",
                        "display_key": "Logo",
                        "display_value": "No"
                    }
                ],
                "sku": "woo-hoodie-blue",
                "price": 45,
                "parent_name": "Hoodie"
            }
        ],

我正在尝试使用以下代码进行pymongo搜索：

mongo_orders = list(col_orders.find({"line_items[0].product_id": 21}, {"_id": 0}))

但它总是一无所获。如何正确地执行此操作

Answer 1

尝试：

mongo_orders = list(col_orders.find({"line_items.0.product_id": 21}, {"_id": 0}))

这是querying an array by index position的一个例子