Hi, We have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created. The postgres console print the next error. ERROR: syntax error at or near ")" at character 617 STATEMENT: SELECT '0' as dataelementid, '0' as categoryoptioncomboid, ou.organisationunitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201308' as periodIsoDate,'dataelementname' as dataelementname, 'optioncomboid' as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and _pav.patientattributeid=280 AND p.organisationunitid in (0) AND _pav.value )='Especial' ) GROUP BY ou.organisationunitid, ou.name
the error is generated when we edit the aggregation query, but it is don't generated with aggregation query that use the attibutes of patient that it is by default. (Sex). Thanks, ING. Helder Yesid Castrillon. Secretaría departamental de salud Date: Mon, 26 Aug 2013 09:21:39 -0500 From: markodavi...@gmail.com To: dhis2-users@lists.launchpad.net Subject: [Dhis2-users] Aggregation Query Builder doesn't count Hello Friends. After migrate to 2.12 version, the aggregation query builder doesn't aggregate the values in the data element. We test with new data elements, simple queries but doesn't work. Maybe the new version has other parameters to aggregate the values?. Thank you very much. -- Regards, Ing. Marko David Garcia M. Área de Sistemas integrados de Información Secretaría de Salud Departamental del Cauca _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
