Hi Devs
Is it possible to get the output of an SQL view from the Web API? (Not
just the definition of the view).
Best regards,
Jason
Hi Devs
Is it possible to get the output of an SQL view from the Web API? (Not
just the definition of the view).
Best regards,
Jason
Not currently, but should be there for (maybe) 2.10.
–
Morten
On Wed, Jul 18, 2012 at 12:05 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Devs
Is it possible to get the output of an SQL view from the Web API? (Not
just the definition of the view).
Best regards,
Jason
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Hi
I have a standard report where when i print the report for national level, i get big number of values showing that it has aggregated all the data from the facilities. However, if i select a particular province, the report comes blank. Also if i select a particular district the report comes blank. But if i select a particular facility, i can get data. That means, the facility in the districts have got data, but DHIS cannot aggregate by district and by province. Is there any one who has experienced this problem? How to fix it?
Lungo
Hi Jason,
from r 7657 you can append /data for xml view of the sql data and
/data.csv for csv view, e.g.
http://apps.dhis2.org/dev/api/sqlViews/dI68mLkP1wN/data
http://apps.dhis2.org/dev/api/sqlViews/dI68mLkP1wN/data.csv
Tell us if you need other resource representations.
regards, Lars
Hi Lungo,
it sounds like you have an incomplete data mart. Please try to export
to data mart again from reports module - this will export for all data
elements for all levels between the selected start and end-date.
regards,
Lars
On Thu, Jul 19, 2012 at 8:16 PM, Juma Lungo <jlungo@yahoo.com> wrote:
Hi
I have a standard report where when i print the report for national level, i
get big number of values showing that it has aggregated all the data from
the facilities. However, if i select a particular province, the report comes
blank. Also if i select a particular district the report comes blank. But if
i select a particular facility, i can get data. That means, the facility in
the districts have got data, but DHIS cannot aggregate by district and by
province. Is there any one who has experienced this problem? How to fix it?Lungo
_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help
Also check if your data elements have "aggregation levels" assigned to
them. You can check this in the "edit" data element screen.
Great Lars. Thanks for this.
On Sat, Jul 21, 2012 at 10:02 AM, Lars Helge Øverland <larshelge@gmail.com> wrote:
Hi Jason,
from r 7657 you can append /data for xml view of the sql data and
/data.csv for csv view, e.g.Tell us if you need other resource representations.
regards, Lars
Thank you boss.
On Sat, Jul 21, 2012 at 9:02 PM, Lars Helge Øverland larshelge@gmail.com wrote:
Hi Jason,
from r 7657 you can append /data for xml view of the sql data and
/data.csv for csv view, e.g.
http://apps.dhis2.org/dev/api/sqlViews/dI68mLkP1wN/data
http://apps.dhis2.org/dev/api/sqlViews/dI68mLkP1wN/data.csv
Tell us if you need other resource representations.
regards, Lars
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
“Expert By Chance”