How to create "sparse" multi document unique index in mongodb?

Question

ive organization id and email(optional) i want to create multidocument unique index for email, as email is optional iam not able to insert two documents with email as null value or a document without email.

ive listed the things which i ve tried

1.createIndex({ "organizationID":1, "email": 1 },{ sparse:true , unique: true});

2.createIndex({ "organizationID":1, "email": 1 },{ partialFilterExpression:{ email:{ $exist: true } }, unique: true});

create sparse index only for email field createIndex({ "email": 1 },{ sparse:true , unique: true}) — Ashh
– Ashh, Commented Jul 21, 2018 at 13:32
unique sparse index works properly on sigle document, but the problem is with multi document sparse indexing — Madhvesh S
– Madhvesh S, Commented Jul 21, 2018 at 13:40

sean · Accepted Answer · 2018-07-21 13:29:38Z

1

Just create a non-unique sparse index.

Since you can have multiple non-unique null values, it's impossible to mark this index as unique.

answered Jul 21, 2018 at 13:29

sean

92711 silver badges17 bronze badges

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

1 Comment

Madhvesh S Over a year ago

createIndex({ "email": 1 },{ sparse:true , unique: true}) works

Collectives™ on Stack Overflow

How to create "sparse" multi document unique index in mongodb?

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