跨多个CosmosDB文档获取唯一的数组值

const { CosmosClient } = require("@azure/cosmos");

// 创建CosmosDB客户端
const endpoint = "<CosmosDB endpoint>";
const key = "<CosmosDB key>";
const client = new CosmosClient({ endpoint, key });

// 定义查询语句
const query = "SELECT DISTINCT c.arrayField FROM c WHERE c.condition = 'value'";

// 执行查询
const container = client.database("<database id>").container("<container id>");
const { resources } = await container.items.query(query).fetchAll();

// 处理查询结果
const uniqueArray = [];
resources.forEach((document) => {
  const arrayField = document.arrayField;
  if (Array.isArray(arrayField)) {
    arrayField.forEach((value) => {
      if (!uniqueArray.includes(value)) {
        uniqueArray.push(value);
      }
    });
  }
});

console.log(uniqueArray);