couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manokaran K <m...@smartgrader.com>
Subject Re: getting list of items spanning a time period
Date Mon, 01 Apr 2013 10:06:07 GMT
I will try your suggestion. Thanks a ton :-)

mano


On Mon, Apr 1, 2013 at 3:30 PM, Robert Newson <robert.newson@gmail.com>wrote:

> oops, the second query should read;
>
> ?startkey=["discharged", <start of time period>]&endkey=["discharged",
> <end of time period>]&reduce=true
>
> On 1 April 2013 10:57, Manokaran K <mano@smartgrader.com> wrote:
> > This is the query am using:
> >
> > 'admission_date<date>:[' + fromDate + '%20TO%20' + tillDate + ']' +
> > '%20OR%20' +
> > 'discharge_date<date>:[' + fromDate + '%20TO%20' + tillDate + ']' +
> > '%20OR%20' +
> >         '\(' +
> > 'admission_date<date>:[' + beforeFromDate + '%20TO%20' + fromDate + ']' +
> > '%20AND%20' +
> > 'discharge_date<date>:[' + tillDate + '%20TO%20' + afterTillDate + ']' +
> > '\)' +
> > '%20OR%20' +
> >         '\(' +
> > 'admission_date<date>:[' + beforeFromDate + '%20TO%20' + fromDate + ']' +
> > '%20AND%20' +
> > 'status:under_treatment' +
> > '\)'
> >
> > thanks,
> > mano
> >
> >
> >
> > On Mon, Apr 1, 2013 at 3:26 PM, Manokaran K <mano@smartgrader.com>
> wrote:
> >
> >> Sorry about the prev resp. The new gmail interface tripped me :-)
> >>
> >>
> >>
> >> On Mon, Apr 1, 2013 at 3:26 PM, Manokaran K <mano@smartgrader.com>
> wrote:
> >>
> >>> 'admission_date<date>:[' + fromDate + '%20TO%20' + tillDate + ']'
+
> >>>  '%20OR%20' +
> >>>  'discharge_date<date>:[' + fromDate + '%20TO%20' + tillDate + ']'
+
> >>> '%20OR%20' +
> >>>  '\(' +
> >>> admission_date<date>:[' + beforeFromDate + '%20TO%20' + fromDate +
']'
> +
> >>> '%20AND%20' +
> >>>  'discharge_date<date>:[' + tillDate + '%20TO%20' + afterTillDate
+
> ']' +
> >>> '\)' +
> >>>  '%20OR%20\(' +
> >>> 'admission_date<date>:[' + beforeFromDate + '%20TO%20' + fromDate
+
> ']' +
> >>>  '%20AND%20' +
> >>> 'status:under_treatment' +
> >>> '\)' +
> >>>
> >>>
> >>>
> >>> On Mon, Apr 1, 2013 at 3:18 PM, Robert Newson <rnewson@apache.org>
> wrote:
> >>>
> >>>> 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, Александр Опак <opak.alexandr@gmail.com>
> wrote:
> >>>> > Use Cron(http://en.wikipedia.org/wiki/Cron) for this =)
> >>>> >
> >>>> >
> >>>> > 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
> >>>> period -
> >>>> >> 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
> >>>> earlier
> >>>> >> than the start of the period but who got discharged after the
time
> >>>> period
> >>>> >> or who are not discharged yet?
> >>>> >>
> >>>> >> Am currently using couchdb-lucene to get this list but would
like
> to
> >>>> know
> >>>> >> 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
> >>>> for
> >>>> >> 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
> >>>> >>
> >>>>
> >>>
> >>>
> >>>
> >>> --
> >>> K Manokaran
> >>> Chief Executive Officer
> >>> MindPlough Analytics Pvt Ltd
> >>> (SmartGrader is the flagship service of MindPlough)
> >>> Mobile: +91 98400 88688
> >>>
> >>
> >>
> >>
> >> --
> >> K Manokaran
> >> Chief Executive Officer
> >> MindPlough Analytics Pvt Ltd
> >> (SmartGrader is the flagship service of MindPlough)
> >> Mobile: +91 98400 88688
> >>
> >
> >
> >
> > --
> > K Manokaran
> > Chief Executive Officer
> > MindPlough Analytics Pvt Ltd
> > (SmartGrader is the flagship service of MindPlough)
> > Mobile: +91 98400 88688
>



-- 
K Manokaran
Chief Executive Officer
MindPlough Analytics Pvt Ltd
(SmartGrader is the flagship service of MindPlough)
Mobile: +91 98400 88688

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message