mongodb查询动态键

发布于 2025-01-22 02:25:32 字数 393 浏览 0 评论 0原文

需要找到具有不同值和键的引用，应从1或2或3开始。请您提供帮助。

{
 "quoteId": 1,
 "screening": {
    "101": 1,
    "201": 1,
    "301": 1,
    "100": 1,
    "200": 1,
    "300": 1,
    "111": 1,
    "211": 1,
    "311": 1
  }
}

{
 "quoteId": 2,
 "screening": {
    "101": 1,
    "201": 1,
    "301": 1,
    "100": 1,
    "200": 1,
    "300": 1,
    "111": 1,
    "211": 2,
    "311": 1
  }
}

原文

Need to find quoteIds where having different values and keys should start with 1 or 2 or 3. Could you please help.

{
 "quoteId": 1,
 "screening": {
    "101": 1,
    "201": 1,
    "301": 1,
    "100": 1,
    "200": 1,
    "300": 1,
    "111": 1,
    "211": 1,
    "311": 1
  }
}

{
 "quoteId": 2,
 "screening": {
    "101": 1,
    "201": 1,
    "301": 1,
    "100": 1,
    "200": 1,
    "300": 1,
    "111": 1,
    "211": 2,
    "311": 1
  }
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

初熏 2025-01-29 02:25:32

$ set - 创建筛选数组字段，通过将对象（键值配对）转换为多个文档（通过$ $ objecttoArray）和通过$ filter的1或2或3的开始来实现正则
$ match - 筛选不是空数组的过滤文档。
$ unset - 删除筛选字段。

db.collection.aggregate([
  {
    $set: {
      screenings: {
        $filter: {
          input: {
            "$objectToArray": "$screening"
          },
          cond: {
            "$regexMatch": {
              input: "$this.k",
              regex: "^(1|2|3)"
            }
          }
        }
      }
    }
  },
  {
    $match: {
      screenings: {
        $ne: []
      }
    }
  },
  {
    $unset: "screenings"
  }
])

示例mongo playground

$set - Create screenings array field, by converting object (key-value pair) to multiple documents (via $objectToArray) and fulfill the regex with starting of 1 or 2 or 3 in $filter.
$match - Filter documents that screenings is not an empty array.
$unset - Remove screenings field.

db.collection.aggregate([
  {
    $set: {
      screenings: {
        $filter: {
          input: {
            "$objectToArray": "$screening"
          },
          cond: {
            "$regexMatch": {
              input: "$this.k",
              regex: "^(1|2|3)"
            }
          }
        }
      }
    }
  },
  {
    $match: {
      screenings: {
        $ne: []
      }
    }
  },
  {
    $unset: "screenings"
  }
])

Sample Mongo Playground

回复收藏 0 原文

~没有更多了~