Sort strange behaviour

[Nicolas Esteban]

Hi,

Here is my query : 

peoples
  .find(Json.obj("id" -> id))
  .options(QueryOpts(page, pageSize))
  .sort(Json.obj("civil.lastname" -> 1))
  .cursor[People].collect[List](pageSize)

It returns a list of People with only civil.lastname filled.

I don't understand why, is there a trick  ?

Thanks in advance.

[Cédric Chantepie]

Hi, please first try the query by hand in the Mongo shell. What's the results by this way?

[Nicolas Esteban]

Is there a way to get the query generated ? I tried before, by setting a lower level of log, but it was a nightmare to catch the query.

2015-10-13 22:30 GMT+02:00 Cédric Chantepie <chantep...@gmail.com>:

Hi, please first try the query by hand in the Mongo shell. What's the results by this way?

--
You received this message because you are subscribed to the Google Groups "ReactiveMongo - http://reactivemongo.org" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reactivemong...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Cédric Chantepie]

Just take the selector and sort documents (in JSON from your code), and call find on the right coll in your shell.