From user-return-22639-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Fri Oct 26 21:02:00 2012 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id ABB1798F0 for ; Fri, 26 Oct 2012 21:02:00 +0000 (UTC) Received: (qmail 24453 invoked by uid 500); 26 Oct 2012 21:01:59 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 24276 invoked by uid 500); 26 Oct 2012 21:01:59 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 24268 invoked by uid 99); 26 Oct 2012 21:01:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2012 21:01:59 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dicky.dicky@gmail.com designates 209.85.220.180 as permitted sender) Received: from [209.85.220.180] (HELO mail-vc0-f180.google.com) (209.85.220.180) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2012 21:01:53 +0000 Received: by mail-vc0-f180.google.com with SMTP id fl13so3266691vcb.11 for ; Fri, 26 Oct 2012 14:01:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type :content-transfer-encoding; bh=eVxFjRYq8a1yzr/4rYW1dfFf8WV9T4EmcpPCUARTK0w=; b=qC0Vvm4oqeoyufA3oLhFxirfWB/Kx6ECv1NM8RfXqi0MReYungdq4+JeXYnacBVvHI F+Vh308sePxSz3HxAYA688r/or1lastB/oUyqMnBt482saMTMn4GIlaj7SaLoYJIKpiy 76B6gJZG9Bdyd3bE1nPSKlhRo3fhJvUbFEz3YtPFHc4WcTQjoVcqcrTR7fwfibkkjjcL YnknzpZmem8CtrGRpy4yfpqpRsKIt3v7NH4ci2T2whSSfmBn24ruffwD6my6l7fBe7tf NmrCH+JRTa6Ld/ND24uB5IJ0o+fFB+T7SIGE6DaximKEfg7lk42fgs8iqY1hU7kYViip r+Rw== MIME-Version: 1.0 Received: by 10.52.95.237 with SMTP id dn13mr31644831vdb.83.1351285292387; Fri, 26 Oct 2012 14:01:32 -0700 (PDT) Sender: dicky.dicky@gmail.com Received: by 10.58.117.36 with HTTP; Fri, 26 Oct 2012 14:01:32 -0700 (PDT) In-Reply-To: <4A95B65F-0EC8-45EE-B91C-72D3C2B62FA3@couchbase.com> References: <4A95B65F-0EC8-45EE-B91C-72D3C2B62FA3@couchbase.com> Date: Fri, 26 Oct 2012 23:01:32 +0200 X-Google-Sender-Auth: ENBGK0Ucde2g41DOVVPQ7njWH44 Message-ID: Subject: Re: how to fetch the newes document of every type? From: Dirk Heilig To: user@couchdb.apache.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org i've already thought about that, bis in my example, ill might get the resul= t: world-news from yesterday world-news from 2 days ago sports-news from last weekend but i want exacly one of a kind, not the last 3 once 2012/10/26 Jens Alfke : > > On Oct 26, 2012, at 12:48 PM, Dirk Heilig wrote: > >> what i need is a view, and the magic wat to query this view to get the >> lastest news of any kind, how do i manage this? > > Emit the =E2=80=98created=E2=80=99 property as the key. Then query the vi= ew in descending order with a limit. > > =E2=80=94Jens