SQL views from the WebAPI

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: 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

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.

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

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