[Rogue] Update an object inside and embedded array

[Riccardo Sirigu]

I have the following model

class BindedEntityBson extends BsonRecord[BindedEntityBson]{
  override def meta: BsonMetaRecord[BindedEntityBson] = BindedEntityBson

  object _id extends ObjectIdField(this)
  object suggested extends BooleanField(this){
    override def defaultValue: Boolean = false
  }
  object excluded extends BooleanField(this){
    override def defaultValue: Boolean = false
  }
}


class Facility extends MongoRecord[Facility] with ObjectIdPk[Facility]{
  override def meta: MongoMetaRecord[Facility] = Facility

  object codify extends StringField(this, 64)
  object bindedServices extends BsonRecordListField(this, BindedEntityBson)

}

And i would like to update bindedServices inside Facility using the following query

      Facility.where(_.codify eqs hotel.code)

        .and(_.bindedServices.subfield(_._id) eqs new ObjectId(service.id))

        .findAndModify(_.bindedServices.subfield(_.suggested) setTo service.suggested)

        .upsertOne(returnNew = true) 

But mongo throws the following exception

Message: com.mongodb.MongoCommandException: Command failed with error 16837: 'cannot use the part (bindedServices of bindedServices.suggested) to traverse the element ({bindedServices: [ { suggested: true, excluded: false, _id: ObjectId('5831abee46e0fb450583090b') } ]})' on server 127.0.0.1:27017. The full response is { "ok" : 0.0, "errmsg" : "cannot use the part (bindedServices of bindedServices.suggested) to traverse the element ({bindedServices: [ { suggested: true, excluded: false, _id: ObjectId('5831abee46e0fb450583090b') } ]})", "code" : 16837 }

What am I doing wrong?


Thank you

[Tim Nelson]

Hi Riccardo,

I don't believe you can update individual items of a list that way. At least not with rogue. But, you may want to try asking over on their list.

Typically, if you need to modify embedded documents, you're usually better off putting them in a separate collection, because there are limitations on how you can query them when embedded.

Tim

[Riccardo Sirigu]

So there is no positional operator in Rogue 

Thank you Tim

[Tim Nelson]

Interesting. I don't believe I've ever used the positional operator. It does look like it does what you want. If rogue doesn't support it, you should be able to write it using lift-json or use the mongo-java-driver directly.

[Riccardo Sirigu]

Thank you Tim, 

I find out that rogue also have a $ operator so I can do something like

....

.modify(_.bindedServices.$.subfield(_.suggested) setTo service.suggested)

[Tim Nelson]

Great. Thanks for following up.