dhis2-devs team mailing list archive

[Pierre Dane <pierre@xxxxxxxxx>]

Hi all,

Although it's not possible to create an event that is linked to a different org unit to the trackedentityinstance org unit through the user interface, this can be done via the api. 
We have a use case where it is normal for events to be registered against different org units, with the org unit of the tracked entity being not very interesting.
I've tested the aggregation and it works on the psi org unit (as can be seen from the validation sql query below) - I'd like to use this paradigm in the momconnect program - we have hundreds of thousands of events, and the program is rolled out nationally.

Can anyone see a problem with doing this?

 I know there have been discussions about not linking tracked entities/enrolments against an org unit - maybe it would be good enough to have that org unit as the 'initially enrolled at' org unit (which would really be the same as the org unit of the first event assuming that the event is registered upon enrolment). So allowing events to be registered against a specific org unit in the front end could solve this.

Thoughts?

Thanks 



SELECT '0' as dataelementid, 
'0' as categoryoptioncomboid, 
'16' as attributeoptioncomboid, 
ou.organisationunitid as sourceid, 
'0' as periodid,
'aggregated_from_tracker' as storedby, 
'201502' as periodIsoDate,
'dataelementname' as dataelementname, 
'optioncomboid' as categoryoptioncomboname, 
ou.name as organisationunitname,  
sum( cast( pdv.value as double precision ) )
FROM trackedentitydatavalue pdv    
INNER JOIN programstageinstance psi ON psi.programstageinstanceid = pdv.programstageinstanceid    
INNER JOIN organisationunit ou ON ou.organisationunitid=psi.organisationunitid
WHERE executiondate >='2015-02-24' AND executiondate <='2015-02-24' AND pdv.dataelementid=null 
AND  EXISTS ( 
	SELECT * 
	FROM trackedentitydatavalue _pdv 
	inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid 
	JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid 
	WHERE psi.programstageinstanceid=_pdv.programstageinstanceid 
	AND _pdv.dataelementid=7256314  
	AND _psi.organisationunitid in (0)    
	AND _pi.programid = 47884 
	AND _psi.executionDate>='2015-02-24' 
	AND _psi.executionDate <= '2015-02-24'  
	AND _psi.programstageid = 7256329  
	AND _pdv.value ='1'  
) 
GROUP BY ou.organisationunitid, ou.name