Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <1FB666F2DE7D4808A469855E74403FA4@cloudant.com>
References: <028101cdbc69$cac8d600$605a8200$@charter.net>
 <1FB666F2DE7D4808A469855E74403FA4@cloudant.com>
From: Mark Hahn <mark@hahnca.com>
Date: Tue, 6 Nov 2012 14:30:38 -0800
Message-ID: 
 <CACrj35Ez5MtFE18dVKLqP_Tb-avbrUAd0SYdgfxRWxa6Rbx=xA@mail.gmail.com>
Subject: Re: Get all documents of a certain type.
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=bcaec554025aec66a204cddb27ca

--bcaec554025aec66a204cddb27ca
Content-Type: text/plain; charset=ISO-8859-1

A view that emitted (_id, sku) would be the easiest and most efficient way
to do it.  You wouldn't have to include_docs.

On Tue, Nov 6, 2012 at 2:05 PM, Simon Metson <simon@cloudant.com> wrote:

> Hi,
> You can query with ?startkey=product&endkey=productZZZZ&include_docs=true
> to get all the product docs back.
>
> If they contain a lot more info than just the SKU's I'd make  a view.
> Cheers
> Simon
>
>
> On Tuesday, 6 November 2012 at 21:58, Kevin Burton wrote:
>
> > In my Couch database I have a mixture of documents. The documents that I
> am
> > interested in have an Id of 'product-xxxxxxx' or 'order-xxxxxx'. The
> > "product" documents have a property of SKU that is a string. I would
> like to
> > form a query to get a list of all the product SKUs. Does this require a
> view
> > in the design document or can it be done all in one request? Thank you.
>
>
>
>

--bcaec554025aec66a204cddb27ca--