Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: Andru Vallance <andru@tinymighty.com>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_3A4C483F-3E32-4AB7-8A50-5B7D98D71F65"
Message-Id: <B7DF3548-4722-4249-AA25-5A124661C8FE@tinymighty.com>
Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\))
Subject: Skipping complex key values in a view function
Date: Sat, 26 Oct 2013 12:06:56 +0200
References: 
 <CAPaJBx52k6U=0b_NaSKJBM-BWEgFuU06uV6dOJodUcMTUVsE5Q@mail.gmail.com>
 <CAGxYWpYps44yZ6-Bzkr5bxZMV2zfsqbFoJpJr-g2RuZz3s-ZWQ@mail.gmail.com>
To: user@couchdb.apache.org
In-Reply-To: 
 <CAGxYWpYps44yZ6-Bzkr5bxZMV2zfsqbFoJpJr-g2RuZz3s-ZWQ@mail.gmail.com>

--Apple-Mail=_3A4C483F-3E32-4AB7-8A50-5B7D98D71F65
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Is there a way to skip a value in a complex key (i.e. an array key) when =
using startkey and end key? That is, is there a way to match any value =
for an item in the array?=20

I have a document with a place_id, plant_id, date_created and =
date_modified. Sometimes I want all docs with place_id=3DX and =
plant_id=3DY, where other times I only want place_id=3DX and any =
plant_id; sometimes I will want to specify a creation and/or =
modification date, other times this will not be relevant.  Since these =
values are all user defined, and it's likely more properties will be =
added in the future, I don't think it's viable to use multiple views =
specific to each use case.

I'm currently using a single view map emitting multiple rows with null =
values to allow me to specify a null value in my startkey/endkey values.

function(doc){
    if(doc.type=3D=3D=3D'planting'){
        emit([doc.place_id, doc.plant_id, doc.date_created, =
doc.date_modified], null);
        emit([doc.place_id, null, doc.date_created, doc.date_modified], =
null);
       emit([null, null, doc.date_created, doc.date_modified], null);
    }
}

Is there a more elegant way I can do this without the multiple row =
emits?

(note: I'm actually using PouchDB and replicating to CouchDB, so this =
map query is actually being run in the browser with PouchDB)

Thanks
Andru Vallance=

--Apple-Mail=_3A4C483F-3E32-4AB7-8A50-5B7D98D71F65--