Are there any plans to add this ability to couchdb? This seems like a common enough use case, for scenarios such as social networking activity feeds, that having built in support in the DB itself would be essential.
Dave On Tue, Jan 13, 2009 at 3:09 PM, Chris Anderson <[email protected]> wrote: > On Tue, Jan 13, 2009 at 3:06 PM, Nicolas Fouché <[email protected]> wrote: >> What if I need documents from Roger and Marcel ? I suppose I cannot >> use the 'keys' query argument in this case, right ? >> > > You'll need to run multiple queries for that. > >> Nicolas >> >> On Tue, Jan 13, 2009 at 10:38 PM, Chris Anderson <[email protected]> wrote: >>> On Tue, Jan 13, 2009 at 1:35 PM, Nicolas Fouché <[email protected]> >>> wrote: >>>> Hi, >>>> >>>> Let's say I have documents like this: {date: '2008/06/09 13:52:11 >>>> +0000', name:'Roger'} >>>> I'd like to find documents matching a name, and sorted by date. I know >>>> that for sorting documents by date, the 'date' field has to be in the >>>> key emitted by the view. >>>> >>>> In this case, what to I have to emit if I need to see only documents >>>> which name is 'Roger' but sorted by date ? >>>> I would do something like: >>>> emit([doc.name, doc.date], null); >>>> >>>> Can I query this view without having to specify the date ? I need >>>> these documents to be sorted by date, because I'll paginate on them. >>> >>> Totally, all you need is a startkey and endkey that bracket the keys >>> you care about. >>> >>> eg startkey=["Roger"] endkey=["Roger",{}] >>> >>> See http://wiki.apache.org/couchdb/View_collation >>> >>>> >>>> Thanks, >>>> Nicolas >>>> >>> >>> >>> >>> -- >>> Chris Anderson >>> http://jchris.mfdz.com >>> >> > > > > -- > Chris Anderson > http://jchris.mfdz.com >
