← Back to team overview

dhis2-devs team mailing list archive

[Bug 1256277] [NEW] Aggregation Query Fails in Comparing Program Stage Age Visit

 

Public bug reported:

I am trying to compare report dates for two program stages and
essentially count the number of times (or visits) when the two are
equal. The Report Date Diff is not set up for this so I am using "Age at
visit (days since birth)" as a proxy. I selected a program stage and
then chose Age at visit under the Program tab.  I then selected the
second program stage and then chose Age at visit. I tried a number of
conditions including, the difference = 0 or division = 1 but but queries
failed.

I think this operation should be possible but have also made an entry in
Blueprints. The use case I have is to calculate Day Patients i.e.
patients who are admitted and discharged from a hospital ward on the
same day (or date). Because of the requirement to have reporting dates
for both admissions and separations, I can't use a single stage program
for this.

Any help or workaround would be most appreciated.

Version:
2.13
Build revision:
12826

Regards,

Busoye

** Affects: dhis2
     Importance: Undecided
         Status: New

** Description changed:

  I am trying to compare report dates for two program stages and
  essentially count the number of times (or visits) when the two are
  equal. The Report Date Diff is not set up for this so I am using "Age at
  visit (days since birth)" as a proxy. I selected a program stage and
  then chose Age at visit under the Program tab.  I then selected the
  second program stage and then chose Age at visit. I tried a number of
  conditions including, the difference = 0 or division = 1 but but queries
  failed.
  
  I think this operation should be possible but have also made an entry in
  Blueprints. The use case I have is to calculate Day Patients i.e.
  patients who are admitted and discharged from a hospital ward on the
  same day (or date). Because of the requirement to have reporting dates
  for both admissions and separations, I can't use a single stage program
  for this.
  
  Any help or workaround would be most appreciated.
  
+ Version:
+ 2.13
+ Build revision:
+ 12826
+ 
  Regards,
  
  Busoye

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1256277

Title:
  Aggregation Query Fails in Comparing Program Stage Age Visit

Status in DHIS 2:
  New

Bug description:
  I am trying to compare report dates for two program stages and
  essentially count the number of times (or visits) when the two are
  equal. The Report Date Diff is not set up for this so I am using "Age
  at visit (days since birth)" as a proxy. I selected a program stage
  and then chose Age at visit under the Program tab.  I then selected
  the second program stage and then chose Age at visit. I tried a number
  of conditions including, the difference = 0 or division = 1 but but
  queries failed.

  I think this operation should be possible but have also made an entry
  in Blueprints. The use case I have is to calculate Day Patients i.e.
  patients who are admitted and discharged from a hospital ward on the
  same day (or date). Because of the requirement to have reporting dates
  for both admissions and separations, I can't use a single stage
  program for this.

  Any help or workaround would be most appreciated.

  Version:
  2.13
  Build revision:
  12826

  Regards,

  Busoye

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1256277/+subscriptions


Follow ups

References