Hi Gonzalo, that is indeed something that is missing in voyage to make that kind of queries more easy. But you can do it using something like that
itemsForUser: aUser ^ Item selectMany: { 'user.__id' -> aUser voyageId } asDictionary Norbert Am 18.09.2014 um 03:06 schrieb gonza <gonzalogte...@gmail.com>: > Hi people, I've been making a small project using Pharo and Voyage, and > everything is going well, but I'm facing a performance issue when retrieving > items from Mongo. > > I've two classes, one for items, and other for users, and both are Root. > Each item contains the user who created it. > > My question is if there's a best way of querying all items for an user, > using selectMany, when you have a document containing another. > > As work-around, by now, I'm making a selectAll and then filter them on > memory, and that takes a lot of time and memory when the collection grows. > > Can you help on this? > > Thanks, > > Gonzalo > > > > -- > View this message in context: > http://forum.world.st/Voyage-selectMany-with-multiple-Root-tp4778705.html > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >