Set index on embedded document in Mongodb

Question

I use mongodb + springdata. My document looks like:

@Entity
@Document(collection="MyCollection")
public final class InfoItemMongoDBDocument {

    @Id
    private ObjectId id;

    @Column
    private String name;

    @Column
    @Indexed
    private int isFixed = 0;


    @Column
    private List<DocumentCopies> copy;

Where is DocumentCopies is POJO. Is it possible to set additional index on one of DocumentCopies field using Spring data annotations.

Thanks a lot!

Neil Lunn · Accepted Answer · 2014-06-23 08:03:42Z

5

Yes, you need a "dot notation" form referencing the field in your other POJO that is to be indexed:

@Document(collection="MyCollection")
@CompoundIndexes({
    @CompoundIndex( name="copy.childField", def="{'copy.childField': 1}")
})

Where "childField" is the name of your "field/property" that is being indexed.

edited Jun 23, 2014 at 8:03

answered Jun 23, 2014 at 7:25

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

4 Comments

EK. Over a year ago

It doesnt work, it creates index on field copy with name copy.mychieldfieldname :(

Neil Lunn Over a year ago

@EK. it should be creating an index in your parent objects mapped collection that is "copy.childField" being the actual name of that field. This should be what you want. You of course use the name of the actual field you are referring to

EK. Over a year ago

Maybe I am wrong but this is it { "v" : 1, "key" : { "copy" : 1 }, "ns" : "Test.MyCollection", "name" : "copy.url", "dropDups" : false, "sparse" : false }

Neil Lunn Over a year ago

@EK. You are right. I had to hack this through @CompoundIndex

Collectives™ on Stack Overflow

Set index on embedded document in Mongodb

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related