Make combination of two fields unique in my collection

Question

I'm using the following Mongoose model:

var Test = db.model('Test', db.Schema({
        one: { type: String, required: true },
        two: { type: String, required: true }
    },
    { strict: false })
);

It has two required fields,oneand two, and strict:false because there can be other fields with undetermined names.

I would like the combination of one and two to be unique. That means there could be multiple documents with the same one or the same two, but none of them should have the same one and two combination.

Can this be achieved with Mongoose?

score 33 · Accepted Answer · answered Jan 12 '16 at 11:31

33

You can enforce a unique constraint on compound indexes, and you can do this in Mongoose using the index() method of the schema, which defines indexes at the schema level:

var testSchema = db.Schema({
    "one": { "type": String, "required": true },
    "two": { "type": String, "required": true }
}, { "strict": false });

testSchema.index({ "one": 1, "two": 1}, { "unique": true });
var Test = db.model("Test", testSchema );

answered Jan 12 '16 at 11:31

chridam

100,957
23
236
235

2

Is there any way to do the same thing if "two" is a ref to another schema ? thanks – issam Eljohri Dec 11 '17 at 12:11
What is this value `1` being provided in `"one": 1`? – Akash Tomar Jun 15 '19 at 17:02
2

@AkashTomar 1 represents ascending order – Madhavan Sundararaj Dec 10 '19 at 04:21
@chridam I have done what you said, but none of works. Here are my question. How to make a real unique on compound indexes? https://stackoverflow.com/questions/63324015/mongodb-compound-index-unique-if-a-and-b-both-are-same – nuclear Aug 09 '20 at 08:15

Make combination of two fields unique in my collection

1 Answers1

Linked