Index containing multiple fields in MongoDB

Question

In MongoDB, How do i restrict the data entry bases on 3 fields RegisterUserId ,PageId and IsFavourite. None of them is unique? what should the query be?

Below is my Schema

var FavMasterSchema = new Schema({
    FavUrl:String,
    RegisterUserId :  { type: Schema.Types.ObjectId, ref: 'User',select: false},
    PageId:  { type: Schema.Types.ObjectId},
    IsFavourite: {type: Boolean,default:false}

});
module.exports = mongoose.model('t_FavMaster', FavMasterSchema);

How do i restrict the data entry bases on 3 fields RegisterUserId ,PageId and IsFavourite. None of them is unique. — Dave1
– Dave1, Commented Feb 19, 2018 at 4:31

Sneha · Accepted Answer · 2018-02-19 05:54:10Z

1

Try this:

var FavMasterSchema = new Schema({
    FavUrl:String,
    RegisterUserId :  { type: Schema.Types.ObjectId, ref: 'User',select: false},
    PageId:  { type: Schema.Types.ObjectId},
    IsFavourite: {type: Boolean,default:false}

});

edited Feb 19, 2018 at 5:54

Sneha

2,2126 gold badges24 silver badges36 bronze badges

answered Feb 19, 2018 at 4:36

Uma

111 bronze badge

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

Collectives™ on Stack Overflow

Index containing multiple fields in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related