查询同类型嵌套文档的Mongo集合

Question

我有一个不那么独特的需求，但我只是找到了正确的术语来搜索，因为我只得到如何查询列表/数组字段或嵌套元素的结果。

public class Item {
    private String identity     = null;
    private String name         = null;
    private String type         = null;
    private List<Item> grouping = null;
}

{
   "identity":"ITEM-1",
   "name":"Pack-1",
   "type":"Bundle",
   "grouping":[
      {
         "identity":"ITEM-2",
         "name":"Book",
         "type":"Atomic Unit"
      },
      {
         "identity":"ITEM-3",
         "name":"Stationary",
         "type":"Bundle",
         "grouping":[
            {
               "identity":"ITEM-4",
               "name":"Pen",
               "type":"Atomic Unit"
            },
            {
               "identity":"ITEM-5",
               "name":"Paper",
               "type":"Atomic Unit"
            },
            {
               "identity":"ITEM-6",
               "name":"Paraphernalia",
               "type":"Bundle",
               "grouping":[
                  {
                     "identity":"ITEM-7",
                     "name":"Eraser",
                     "type":"Atomic Unit"
                  },
                  {
                     "identity":"ITEM-8",
                     "name":"Ruler",
                     "type":"Atomic Unit"
                  },
                  {
                     "identity":"ITEM-9",
                     "name":"Compass",
                     "type":"Atomic Unit"
                  }
               ]
            }
         ]
      }
   ]
}

提前感谢所有的帮助。

Answer 1

我的要求是能够搜索书或笔或指南针，必须能够获取记录项目-1。

您可以从mongoshell尝试该查询，它将获取文档：

var SEARCH_ITEMS = [ "Book", "Pen", "Compass" ]
var ATOMIC = "Atomic Unit"

db.collection.find( {
  $or: [
    { "type": ATOMIC, name: { $in: SEARCH_ITEMS } },
    { "grouping.type": ATOMIC, "grouping.name": { $in: SEARCH_ITEMS } },
    { "grouping.grouping.type": ATOMIC, "grouping.grouping.name": { $in: SEARCH_ITEMS } },
    { "grouping.grouping.grouping.type": ATOMIC, "grouping.grouping.grouping.name": { $in: SEARCH_ITEMS } }
  ]
} )