ReactiveMongo: find query with cursor[BSONObjectID]

Question

My query using ReactiveMongo:

collection
  .find(
    Json.obj("relateds" -> Json.obj("$elemMatch" -> activityRelated)),
    Json.obj("subscriberId" -> 1, "_id" -> 0)
  )
  .cursor[BSONObjectID]
  .collect[Seq]()

This is meant to return only one field "subscriberId" for each found document. The final output type should be Future[Seq[BSONObjectID]]

But it fails with:

Failure(java.lang.RuntimeException: JsError(List((,List(ValidationError(unhandled json value,WrappedArray()))))))

Any Ideas how to do this ?

Thanks in advance

score 2 · Accepted Answer · answered Apr 30 '14 at 13:57

Response for this query is sequence of objects, not values:

{ subscriberId : "foo" }

So, you need to define case class with single field for this id and then set cursor type as this case class or try something like that:

collection
  .find(
     Json.obj("relateds" -> Json.obj("$elemMatch" -> activityRelated)),
     Json.obj("subscriberId" -> 1, "_id" -> 0)
  )
  .cursor[JsValue]
  .collect[Seq]() 
  .map(_.map(_.\("subscriberId").as[BSONObjectID]))

The second solution is what I am looking for. Thanks – Ayoub Apr 30 '14 at 14:05 — Ayoub, Apr 30 '14 at 14:05

ReactiveMongo: find query with cursor[BSONObjectID]

1 Answers1