Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of jchris@gmail.com designates
 209.85.160.56 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=AoXS53kRVLjAhKyGXiIY5efr06IX8ZJNO6t80Q27G6tW7PF5BQzglRbHDnmf/JzqIF
         nZs22wGZTgOS+1e+C+QJlef1f6R/P/26YFF2+bVXIeO3YV/tL6yt5d2FUhYzykUEUpg8
         6YmLefoHavmdACtHkPjjFRn7a1XhZQuKH6nxQ=
MIME-Version: 1.0
Sender: jchris@gmail.com
In-Reply-To: <255598.898.qm@web24818.mail.ird.yahoo.com>
References: <255598.898.qm@web24818.mail.ird.yahoo.com>
Date: Fri, 22 Jan 2010 10:41:03 -0800
Message-ID: <e282921e1001221041q4525403cmd83a5ff1d5dca524@mail.gmail.com>
Subject: Re: view syntax for retrieving object without a field
From: Chris Anderson <jchris@apache.org>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Fri, Jan 22, 2010 at 7:38 AM, Matt Villiers <mattvilliers@yahoo.fr> wrot=
e:
> I'm prototyping couchdb for a large application (for a possible migration=
 from an oracle system).
>
> I'l like to query my objects to get those _without_ a certain key.
> My data:
> {'id':'2','Type':'Article', country:'USA'}
> {'id':'3','Type':'Article', country:'USA'}
> {'id':'4','Type':'Article',}
> {'id':'5','Type':'Article', country:null}
>
> I'd like to get the object number 4 (no field 'country').
>
> I tried with this view:
>
> =A0 =A0 =A0 =A0 =A0 =A0function(doc) {
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0if =A0(doc.Type =3D=3D "Article") {
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0emit('country' in doc, doc);
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0}
> =A0 =A0 =A0 =A0 =A0 =A0}
>
 function(doc) {
    if (doc.Type =3D=3D "Article") {
      if (doc.country) {
        emit(doc.country, null);
      } else {
        emit("--no-country", null);
      }
    }
  };

instead of "--no-country" you could emit false, but currently if there
is no .country field then CouchDB will just skip the row.

there are plans to make it so that attempts to emit undefined will be
coerced to null (this is in keeping with the ecma5 standard) but that
won't change things materially for you.

Chris


> With False as the request key but with no luck ...
>
> Is that feasible with couchdb ? Could you advise ?
>
> Best,
>
> Matt
>
>
>
>


--=20
Chris Anderson
http://jchrisa.net
http://couch.io