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 carl.bourne@me.com designates
 17.158.236.241 as permitted sender)
MIME-version: 1.0
Content-type: text/plain; charset=utf-8
References: <620C985E-E1AC-48C9-8EC4-7C3F42C98FF5@me.com>
 <8B7BA084-B1C0-46FA-95CA-8065947B8F29@utt.fr>
 <65464099-C893-4A3F-9466-88298C55A37E@me.com>
 <8D941ACF-A15F-4651-9F5B-F378E9D5D05B@utt.fr>
In-reply-to: <8D941ACF-A15F-4651-9F5B-F378E9D5D05B@utt.fr>
Content-transfer-encoding: quoted-printable
Message-id: <75098634-1472-45F0-B03D-A8F5C8CA1E94@me.com>
Cc: "user@couchdb.apache.org" <user@couchdb.apache.org>
From: Carl Bourne <carl.bourne@me.com>
Subject: Re: Help with reduce function
Date: Sat, 06 Oct 2012 21:07:10 +0100
To: "user@couchdb.apache.org" <user@couchdb.apache.org>

Thanks again, but I still not quite sure how this would work for me.=20

My documents have expiry dates and I need the ability to build queries that o=
nly returns documents that have an expiry date between the startkey and endk=
ey parameters.=20

Sorry if I'm being dumb here!=20

Carl Bourne | Senior Sales Engineer | mobile: +44 (0) 7770 284294 | www.vena=
fi.com

On 6 Oct 2012, at 20:58, Aur=C3=A9lien B=C3=A9nel <aurelien.benel@utt.fr> wr=
ote:

>> I need the ability to query by date. I don't quite understand what you me=
an by your last comment with regards date. Please could you elaborate?
>=20
> If your view is like this:
> ["UK", 2011, 10, 6, 20, 30]        null
> ["UK", 2011, 9, 31, 7, 59]        null
> ["UK", 2012, 10, 6, 21, 31]        null
> ["USA", 2011, 9, 1, 12, 00]        null
> ["USA", 2012, 10, 5, 8, 10]        null
> ["USA", 2012, 10, 6, 20, 03]    null
> ["USA", 2012, 10, 6, 21, 31]    null
> ["USA", 2012, 10, 6, 21, 40]    null
>=20
> You can query it with group_level=3D5 and get:
> ["UK", 2011, 10, 6, 20]        1
> ["UK", 2011, 9, 31, 7]        1
> ["UK", 2012, 10, 6, 21]        1
> ["USA", 2011, 9, 1, 12]        1
> ["USA", 2012, 10, 5, 8]        1
> ["USA", 2012, 10, 6, 20]    1
> ["USA", 2012, 10, 6, 21]    2
>=20
> with group_level=3D4:
> ["UK", 2011, 10, 6]    1
> ["UK", 2011, 9, 31]    1
> ["UK", 2012, 10, 6]    1
> ["USA", 2011, 9, 1]    1
> ["USA", 2012, 10, 5]    1
> ["USA", 2012, 10, 6]    3
>=20
> with group_level=3D3:
> ["UK", 2011, 10]    1
> ["UK", 2011, 9]    1
> ["UK", 2012, 10]    1
> ["USA", 2011, 9]    1
> ["USA", 2012, 10]    4
>=20
> with group_level=3D2:
> ["UK", 2011]        2
> ["UK", 2012]        1
> ["USA", 2011]    1
> ["USA", 2012]    4
>=20
> with group_level=3D1:
> ["UK"]    3
> ["USA"]    5
>=20
> So to get all of these stats, you just need to split the date into year, m=
onth, hour, minute when you emit the key.
>=20
>=20
> Regards,
>=20
> Aur=C3=A9lien
>=20