Yeah, I'm trying to get the latest document for each user in one query rather than one query per user.
On Thu, Nov 11, 2010 at 4:11 PM, Matthew Woodward <[email protected]>wrote: > On Thu, Nov 11, 2010 at 12:59 PM, Mike Bannister <[email protected] > >wrote: > > > I have a set of documents that are related to users in my system and each > > document has a timestamp. What's the CouchDB way of getting the latest > > document for each user? > > > I'm pretty new to CouchDB as well so take this for what it's worth--in one > of our databases we needed to get the most recent document based on a > timestamp, so we just have a view called "byDate" with the key being the > timestamp, and then we just call the view like this: > > http://server/database/_design/designname/_view/byDate?descending=true&limit=1 > > Not sure that's quite what you're after and might not address the user part > of what you're doing, but hope that helps a bit. > > -- > Matthew Woodward > [email protected] > http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html >
