converting the $in to a query

[Akka Chelley]

Was reading the mongodb documentation.

http://docs.mongodb.org/manual/reference/operator/query/in/#op._S_in

• db.CollectionName.find( { qty: { $in: [ 5, 15 ] } } )
  

Any idea how this translates to a query to my basically defining the "query"

val f : Future[Seq[Foobar]] = somCollection.find(query).cursor[FOO].collect[Seq]()

I tried this -- doesn't seem to work.

    val query = BSONDocument(

      "mygroupId" -> BSONDocument(

        "$in" -> BSONArray(someIds.map(convertoBSONString).toStream)

      )

    )

Thanks

_D

[Jaap Taal]

Hey there,

If you import reactivemongo.bson._ you get the implicit function collectionToBSONArrayCollectionWriter into scope. It will basicly allow you to implicitly convert a collection into a BSONArray.

You should be able to write your query as:

val query = BSONDocument(

  "mygroupId" -> BSONDocument(

    "$in" -> someIds

  )

)

Jaap

[Jaap Taal]

BTW this implicit magic isn't very well documented, at least I haven't really seen it. I've learned about the implicit conversions available by looking at the source:

https://github.com/ReactiveMongo/ReactiveMongo/blob/master/bson/src/main/scala/handlers.scala

[Akka Chelley]

This works brilliantly! thanks Jaap Taal

_D