MongoDb Distinct query

[Chris Hagan]

Hi Lifters!

I apologise if this is retreading old ground, but could anyone point
me towards a way to execute the following query:

> db.userinformations.distinct("groups")

in mongodb-record?

What I've had to settle for at the moment is

Set(UserInformation.findAll.flatMap(_.groups.is))

which is not, of course, the same thing at all.

Thanks!

c

[Chris Hagan]

Ah, for posterity, here's one solution. I'm eager to hear a more
expert one though!

MongoDB.useCollection("userinformations")(_.distinct("groups"))

c

[Tim Nelson]

Hi Chris,

That's the way to do it. If you write it inside your MetaRecord object there's a useColl function that would use the collection name defined directly, so you could just write:

def distinctGroups = useCall(_.distinct("groups"))

Tim

[Chris Hagan]

Thanks very much, Tim. It did indeed to turn out to be very neat that
way.

c