Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CA+7mGNwnhfmgyxEd73okVrLZTbEY45E_yBgJ2gdq9ndg6_0r4w@mail.gmail.com>
References: 
 <CAKGmkL31-MD8+XR+_+6j9-Wfwi3cHFBQEACKxktFBgj0U=93BA@mail.gmail.com>
	<CA+7mGNwnhfmgyxEd73okVrLZTbEY45E_yBgJ2gdq9ndg6_0r4w@mail.gmail.com>
Date: Mon, 1 Apr 2013 10:48:24 +0100
Message-ID: 
 <CABvT1DFgf3c1ziVOizn44EERPt-Hk7o74WKkzbezxbcGpwJuEw@mail.gmail.com>
Subject: Re: getting list of items spanning a time period
From: Robert Newson <rnewson@apache.org>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I'm not sure it's possible in a couchdb view, at least not a single
call or view. The best I can think of a view keyed on admission_time
and another on discharge_time. You'd have to do the set subtraction
yourself, though. couchdb-lucene obviously does this for you. I assume
you're doing boolean queries using admission_time and discharge_time
fields?


B.

On 1 April 2013 10:38, =D0=90=D0=BB=D0=B5=D0=BA=D1=81=D0=B0=D0=BD=D0=B4=D1=
=80 =D0=9E=D0=BF=D0=B0=D0=BA <opak.alexandr@gmail.com> wrote:
> Use Cron(http://en.wikipedia.org/wiki/Cron) for this =3D)
>
>
> 2013/4/1 Manokaran K <manokaran@gmail.com>
>
>> Hi,
>>
>> Am working on an hospital information system using couchdb and node.js. =
For
>> this I need to get the list and number of patients in a given time perio=
d -
>> usually a day. I can get the patients who were admitted or discharged in
>> that time period. How to get the list of patients who were admitted earl=
ier
>> than the start of the period but who got discharged after the time perio=
d
>> or who are not discharged yet?
>>
>> Am currently using couchdb-lucene to get this list but would like to kno=
w
>> if there is a way where I can get it from a view - that way I can just
>> reduce and get the number of patients in a given period. I was wondering=
 if
>> I should use a scheduler that will create a new 'under_treatment' doc fo=
r
>> every day till the patient is discharged! Or is there a simpler way?
>>
>> Thanks in advance,
>> mano
>>
>> --
>> Lord, give us the wisdom to utter words that are gentle and tender, for
>> tomorrow we may have to eat them.
>>     -Sen. Morris Udall
>>