dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #26362
[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