How to modify a specific object in an array?

Question

MongoDB

I have databases Users, Groups.
Groups have settings, they are unique and dependent on Users. I am looking for the best way to implement this.

const Users = new Schema({
  Groups: [
     {
      type: Schema.Types.ObjectId,
      ref: 'Groups'
    }
  ]
})
const Groups = new Schema({
  settings: [
    User: {
      type: Schema.Types.ObjectId,
      ref: 'Users'
    },
    ...
  ]
})

Everything seems to be perfect, but not completely. Each time I will have to look for the desired group, in the group document, look for the desired object in the settings array.
Is there a way to modify the settings object I need in a more convenient way? Or change the structure of the collection to get this convenience.

Answer 1

Perhaps this will work https://docs.mongodb.com/manual/reference/operator...