dhis2-users team mailing list archive

[helder yesid castrillon cobo <helder_947@xxxxxxxxxxx>]

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: markodavidgm@xxxxxxxxx
To: dhis2-users@xxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp