时间戳

首页 > 解决方案 > MongoDB查询双嵌套数组

mongodb - MongoDB查询双嵌套数组

问题描述

下面是我的名为 business 的 mongo db 文档

{
  "_id": ObjectId("5be8e24a6600321ead321466"),
  "business_id": "r89Re4FNgVWHgBfjCVZyVw",
  "name": "Harlow",
  "neighborhood": "Ville-Marie",
  "address": "438 Place Jacques Cartier",
  "city": "Montréal",
  "state": "QC",
  "postal_code": "H2Y 3B3",
  "stars": 3.5,
  "attributes": {
    "Alcohol": "full_bar",
    "BikeParking": "True",
    "BusinessAcceptsCreditCards": "True",
    "BusinessParking": "{'garage': False, 'street': False, 'validated': False, 'lot': False, 'valet': False}",
    "Caters": "False",
    "GoodForMeal": "{'dessert': False, 'latenight': False, 'lunch': False, 'dinner': False, 'breakfast': False, 'brunch': False}",
    "RestaurantsDelivery": "False",
    "RestaurantsGoodForGroups": "True",
  },
  "categories": "Nightlife, Bars, American (Traditional), Tapas/Small Plates, Poutineries, Supper Clubs, Restaurants, Tapas Bars",
}

问题：在上述名为 business 的集合中，我需要查找所有提供午餐的餐厅。（需要检查属性-GoodForMeal-lunch）

它是嵌套数组。请建议我如何使用 mongo db 来完成

标签： mongodbmultidimensional-array

解决方案

推荐阅读