如何选择和返回MongoDB中的内部对象

Question

我只想从下面的文档的单一形式中检验响应，我正在使用pymongo，所以我正在使用.find（）方法。

我所做的每个查询也会返回其他字段，因此我对需要使用哪些参数感到困惑。

这很奇怪，因为我尝试使用：

pprint(list(collection.find(
    {'forms.id': "33b66684-24a9-4a45-a12f-27a330152ac8"}, {'forms': 1, '_id': 1}
)))

它返回两种形式而不是一种形式。

[
    {
        "_id": ObjectId("6283a32ab85dce6cc4869bb9"),
        "company": "turivius",
        "forms": [
            {
                "current_version": 0,
                "history": [
                    {
                        "content": [
                            {
                                "field_id": 1,
                                "helperText": "qualquer arquivo",
                                "type": "file",
                            }
                        ],
                        "layout": [
                            {"h": 50, "id": 1, "type": "file", "w": 100, "x": 0, "y": 1}
                        ],
                        "responses": [
                            {
                                "client_id": 100,
                                "response_date": datetime.datetime(2022, 5, 17, 3, 0),
                                "values": [
                                    {"field_id": 0, "value": "um texto"},
                                    {"field_id": 1, "value": "ICIwIn0="},
                                ],
                            }
                        ],
                        "version": 0,
                    }
                ],
                "id": "33b66684-24a9-4a45-a12f-27a330152ac8",
                "is_active": True,
            },
            {
                "current_version": 0,
                "history": [],
                "id": "fa2eb9a1-c7c4-4b64-b682-7f51658bc4ab",
                "is_active": True,
                "name": "Vrau",
            },
        ],
        "user_id": "1",
    },
    {
        "_id": ObjectId("6283f19f066cf68667a9327d"),
        "company": "turivius",
        "forms": [],
        "user_id": "-1",
    },
]

进行查询后，我想返回：

[
    {
        "client_id": 100,
        "response_date": datetime.datetime(2022, 5, 17, 3, 0),
        "values": [
            {"field_id": 0, "value": "um texto"},
            {"field_id": 1, "value": "ICIwIn0="},
        ],
    }
]

Answer 1

与 表单字段的操作员。

db.collection.find({
  "forms.id": "33b66684-24a9-4a45-a12f-27a330152ac8"
},
{
  "forms.$": 1,
  "_id": 1
})