How to setup unique index on an element in embeded array of elements

Question

I have collection of documents, witch has an array, of embedded documents, how i can setup unique key on a field in these array?

example collection

{
    field:1
    field2: [
       {field3:1, field4:4},
       {field3:1, field4:5},
    ]
}

i would like to ensure that "field4" of array "field2" is unique across all documents in collection?

gogu · Accepted Answer · 2010-12-04 00:53:23Z

1

You would need a separate collection holding field4 values, which would act as an index.

answered Dec 4, 2010 at 0:53

gogu

812 bronze badges

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

1 Answer 1