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

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

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中迭代数组的很好的博客。