dhis2-users team mailing list archive

["Wilson, Randy" <rwilson@xxxxxxx>]

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.*