azure - Cosmos 查询获取列表中的项目

Question

我有一个这样的数据结构:

{
  "commonId":"123",
  "Answers": [
    {
        "QuestionType": "1",
        "Answer": [
            "answer1"
        ]
    },
    {
        "QuestionType": "1",
        "Answer": [
            "answer2"
        ]
    },
    {
        "QuestionType": "2",
        "Answer": [
            "answer14"
        ]
    }
]
}

另一个文件

 {
  "commonId":"123",
  "Answers": [
    {
        "QuestionType": "1",
        "Answer": [
            "answer3."
        ]
    },
    {
        "QuestionType": "1",
        "Answer": [
            "answer4."
        ]
    },
    {
        "QuestionType": "3",
        "Answer": [
            "answer24."
        ]
    }
]
}

在这里，我只想将具有 commonId:123 的 QuestionType=1 的答案提取到字符串列表中。我尝试了下面的代码，但它不起作用

string sqlQueryText = "SELECT c.Answers.Answer FROM c WHERE c.commonId=123 AND c.Answers.QuestionType=1";
QueryDefinition queryDefinition = new QueryDefinition(sqlQueryText);
FeedIterator<List<string>> queryResultSetIterator = cosmosContainer.GetItemQueryIterator<List<string>>(queryDefinition);
FeedResponse<List<string>> currentResultSet = await queryResultSetIterator.ReadNextAsync();

我是这个 azure-cosmosdb 的新手，目前我正在获取所有问题类型的所有答案，并使用 linq 过滤特定问题的答案。

Answer 1

您将需要使用联接。您的查询将如下所示。

SELECT t.Answer
FROM c
JOIN t IN c.Answers
WHERE t.QuestionType = "1" AND c.commonId = 123

回复如下。

[
    {
        "Answer": [
            "answer1."
        ]
    },
    {
        "Answer": [
            "answer2."
        ]
    },
    {
        "Answer": [
            "answer3."
        ]
    },
    {
        "Answer": [
            "answer4."
        ]
    }
]

您可以查看这个关于在 Cosmos 中迭代数组的非常好的博客 LINK .