Docs 菜单

Docs 主页 → 启动和管理 MongoDB → MongoDB Atlas

1

连接到 mongosh中的集群。

在终端窗口中打开mongosh并连接到集群。有关连接的详细说明，请参阅通过mongosh连接。

2

切换到sample_analytics数据库。

在mongosh提示符下运行以下命令：

use sample_analytics
switched to db sample_analytics
3

使用 Atlas Search$lookup$search 查询运行以下 。

以下查询使用以下阶段：

  • $lookup 以执行以下操作：

    • 根据客户的账户 ID 连接 sample_analytics 数据库中的 customers 和 accounts 集合，并在名为 purchases 的数组字段中返回 accounts 集合中的匹配文档。

    • 使用子管道中的 $search 阶段搜索 must 已购买 CurrencyService 和 InvestmentStock 的客户帐户，并优先选择介于 5000 和10000 之间的订单限制。

  • $limit阶段将输出限制为5结果。

  • $project 阶段以排除结果中的指定字段。

db.customers.aggregate([
  {
    $lookup:{
      "from": "accounts",
      "localField": "accounts",
      "foreignField": "account_id",
      "as": "purchases",
      "pipeline": [{
        "$search": {
          "index": "lookup-with-search-tutorial",
          "compound": {
            "must": [{
              "queryString": {
                "defaultPath": "products",
                "query": "products: (CurrencyService AND InvestmentStock)"
              }
            }],
            "should": [{
              "range": {
                "path": "limit",
                "gte": 5000,
                "lte": 10000
              }
            }]
          }
        }
      },{
        "$project": {
          "_id": 0
        }
      }]
    }
  },{
    "$limit": 5
  },{
    "$project": {
      "_id": 0,
      "address": 0,
      "birthdate": 0,
      "username": 0,
      "tier_and_details": 0
    }
  }
])
[
  {
    name: 'Elizabeth Ray',
    email: 'arroyocolton@gmail.com',
    active: true,
    accounts: [ 371138, 324287, 276528, 332179, 422649, 387979 ],
    purchases: [
      {
        account_id: 422649,
        limit: 10000,
        products: [ 'CurrencyService', 'InvestmentStock' ]
      },
      {
        account_id: 324287,
        limit: 10000,
        products: [
          'Commodity',
          'CurrencyService',
          'Derivatives',
          'InvestmentStock'
        ]
      },
      {
        account_id: 332179,
        limit: 10000,
        products: [
          'Commodity',
          'CurrencyService',
          'InvestmentFund',
          'Brokerage',
          'InvestmentStock'
        ]
      }
    ]
  },
  {
    name: 'Lindsay Cowan',
    email: 'cooperalexis@hotmail.com',
    accounts: [ 116508 ],
    purchases: []
  },
  {
    name: 'Katherine David',
    email: 'timothy78@hotmail.com',
    accounts: [ 462501, 228290, 968786, 515844, 377292 ],
    purchases: [
      {
        account_id: 228290,
        limit: 10000,
        products: [
          'CurrencyService',
          'InvestmentStock',
          'InvestmentFund',
          'Brokerage'
        ]
      },
      {
        account_id: 515844,
        limit: 10000,
        products: [
          'Commodity',
          'CurrencyService',
          'InvestmentFund',
          'Brokerage',
          'InvestmentStock'
        ]
      }
    ]
  },
  {
    name: 'Leslie Martinez',
    email: 'tcrawford@gmail.com',
    accounts: [ 170945, 951849 ],
    purchases: []
  },
  {
    name: 'Brad Cardenas',
    email: 'dustin37@yahoo.com',
    accounts: [ 721914, 817222, 973067, 260799, 87389 ],
    purchases: [
      {
        account_id: 87389,
        limit: 10000,
        products: [ 'CurrencyService', 'InvestmentStock' ]
      },
     {
        account_id: 260799,
        limit: 10000,
        products: [
          'Brokerage',
          'InvestmentStock',
          'Commodity',
          'CurrencyService'
        ]
      }
    ]
  }
]
MongoDB Atlas 是什么？ →