Creating MongoDB index for all items in array

Question

I have some documents in my mongodb database with the following structure, I want to know how to create an index for document.data.0.data[0-9999].val1?

My problem is where I type [0-9999] I don't know how many elements will be inside this data array, but I want that all the elements inside this array have an index on the val1 key.

Any tips?

{
  "_id" : ObjectId("55c455c2fc07853b78c4b6b9"),     
  "data": {
    "0": {
      "data": [
      {
        val1: "abc",
        val2: "def"
      },
      {
        val1: "abc",
        val2: "def"
      }
      ]
    }
  }
}

JohnnyHK · Accepted Answer · 2015-08-24 03:49:18Z

1

You don't include the array index values in the index, so it would just be:

db.mycoll.ensureIndex({'data.0.data.val1': 1})

This is termed a multikey index in MongoDB.

edited Aug 24, 2015 at 3:49

answered Aug 23, 2015 at 18:26

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

justcode Over a year ago

I will try. It will know that it must create the index for all the elements?

Collectives™ on Stack Overflow

Creating MongoDB index for all items in array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related