dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Randy,

this sounds like a good fit for the new sql view variables feature in 2.20:

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s24.html#d5e3146

You can also use criteria (slightly less performant), see documentation on
how to define the query + url parameters in the docs:

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s24.html#d5e3139


regards,

Lars




On Tue, Aug 25, 2015 at 5:56 PM, Wilson, Randy <rwilson@xxxxxxx> wrote:

> Hi All,
>
> We're trying to synch facility data between DHIS-2 and a new Provider
> Registry linked to iHRIS using the API.  I've created a SQL view that works
> nicely to pull all of the data and I am able to filter for exact matches
> (e.g.).  (I can't seem to get the FRED API to work in version 2.20).
>
>
> https://hmis.moh.gov.rw/hmis/api/sqlViews/LQ83r2JDHKw/data.xml?criteria=Type:Health
> Center
>
> but we would also like to filter by a date range fore example:
> lastupdated>2015-01-01.  This does not seem to work .... not even sure
> where to put the > sign, should it be criteria>lastupudated:2015-01-01?
>
> Also, have we fixed the issue where Analytics tries to drop and rebuild
> all resource tables and SQL views before running.  My SQL view refers to
> _orgunitstructure in order to select only level 6 facilities.  In the past
> it could not drop _orgunitstructure because it was referred to in a view
> and analytics failed.
>
> Any suggestions?
>
> --
> *Randy Wilson*
> *Team Leader: **Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Direct: +250 788308835
> E-mail: rwilson@xxxxxxx
> Skype: wilsonrandy_us
> <http://www.msh.org/>
> Stronger health systems. Greater health impact.
> <https://www.facebook.com/ManagementSciencesForHealth>
> <https://twitter.com/MSHHealthImpact>
> <https://www.youtube.com/user/MSHHealthImpact>
> www.msh.org
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>