Aggregation Query Builder doesn't count

Support - Assistance technique
1

Hello Friends.
After migrate to 2.12 version=2C the aggregation query builder doesn't aggr=
egate the values in the data element. We test with new data elements=2C si=
mple queries but doesn't work. Maybe the new version has other parameters=
to aggregate the values?.=0A=

Thank you very much.=20
--=20
Regards=2C

Ing. Marko David Garcia M.
=0A=
=C1rea de Sistemas integrados de Informaci=F3n
Secretar=EDa de Salud Departamental del Cauca

=0A=
=0A=
=0A=

_______________________________________________=0A=
Mailing list: https://launchpad.net/~dhis2-users=0A=
Post to : dhis2-users@lists.launchpad.net=0A=
Unsubscribe : https://launchpad.net/~dhis2-users=0A=
More help : ListHelp - Launchpad Help =

--_bcf798be-2e1b-4e12-92e1-fd327b129a06_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 12pt=3B
font-family:Calibri
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>Hi=2C 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. <br>The postgres console pr=
int the next error.<br>&nbsp=3B<br><b>ERROR: syntax error at or near ")" at=
character 617<br>STATEMENT: SELECT '0' as dataelementid=2C '0' as category=
optioncomboid=2C ou.organisationunitid as sourceid=2C '0' as periodid=2C'DH=
IS-SYSTEM' as comment=2C '201308' as periodIsoDate=2C'dataelementname' as d=
ataelementname=2C 'optioncomboid' as categoryoptioncomboname=2C ou.name as =
organisationunitname=2C count (psi.programinstanceid ) as value FROM progra=
mstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunit=
id=3Dpsi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributeva=
lue _pav WHERE _pav.patientid =3D pi.patientid and _pav.patientattributeid=
=3D280 AND p.organisationunitid in (0) AND _pav.value )=3D'Especial' ) GROU=
P BY ou.organisationunitid=2C ou.name</b><br><br>the error is generated whe=
n we edit the aggregation query=2C but it is don't generated with aggregati=
on query that use the attibutes of patient that it is by default. (Sex).<br=

<br>Thanks=2C <br><br>ING. Helder Yesid Castrillon.<br>Secretar=EDa depart=

amental de salud<br><br><br><div><hr id=3D"stopSpelling">Date: Mon=2C 26 Au=
g 2013 09:21:39 -0500<br>From: markodavidgm@gmail.com<br>To: dhis2-users@li=
sts.launchpad.net<br>Subject: [Dhis2-users] Aggregation Query Builder doesn=
't count<br><br><div dir=3D"ltr">Hello Friends.<div><br></div><div>After mi=
grate to 2.12 version=2C the aggregation query builder doesn't aggregate th=
e values in the data element. &nbsp=3BWe test with new data elements=2C sim=
ple queries but doesn't work. &nbsp=3B Maybe the new version has other para=
meters to aggregate the values?.</div>=0A=
<div><br></div><div>Thank you very much.</div><div>&nbsp=3B<br clear=3D"all=
"><div><br></div>-- <br>Regards=2C<div><br><br><font face=3D"arial=2C helve=
tica=2C sans-serif"><b><font color=3D"#336666">Ing. Marko David Garcia M.<b=

</font></b></font><div>=0A=

<font face=3D"arial=2C helvetica=2C sans-serif"><b><font color=3D"#336666">=
=C1rea de Sistemas integrados de Informaci=F3n<br>Secretar=EDa de Salud Dep=
artamental del Cauca<br><font color=3D"#3333ff"><br></font></font></b></fon=

<br></div>=0A=

</div>=0A=
</div></div>=0A=
<br>_______________________________________________=0A=
Mailing list: https://launchpad.net/~dhis2-users=0A=
Post to : dhis2-users@lists.launchpad.net=0A=
Unsubscribe : https://launchpad.net/~dhis2-users=0A=
More help : https://help.launchpad.net/ListHelp&lt;/div&gt; </div></=

</html>=

--_bcf798be-2e1b-4e12-92e1-fd327b129a06_--