Aggregation Query Builder doesn't count

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 =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 =

--_47424454-041a-4e05-b53a-25738487c2ed_
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'>sorry!!<br><br>SEX =3D gender<br=

In spanish genero=2C sexo.<br><br>ING. Helder Yesid Castrillon.<br><br><br=
<br><div><hr id=3D"stopSpelling">From: helder_947@hotmail.com<br>To: marko=

davidgm@gmail.com=3B dhis2-users@lists.launchpad.net<br>Date: Tue=2C 27 Aug=
2013 00:43:56 +0200<br>Subject: Re: [Dhis2-users] Aggregation Query Builde=
r doesn't count<br><br>=0A=
=0A=
<style><!--=0A=
.ExternalClass .ecxhmmessage P {=0A=
padding:0px=3B=0A=
}=0A=
=0A=
.ExternalClass body.ecxhmmessage {=0A=
font-size:12pt=3B=0A=
font-family:Calibri=3B=0A=
}=0A=
=0A=
--></style>=0A=
<div dir=3D"ltr">Hi=2C We have reviewed in detail and we found that the pro=
blem is presented with aggregation query that use the attribute of patient =
that we have created. <br>The postgres console print the next error.<br>&nb=
sp=3B<br><b>ERROR: syntax error at or near ")" at character 617<br>STATEMEN=
T: SELECT '0' as dataelementid=2C '0' as categoryoptioncomboid=2C ou.organi=
sationunitid as sourceid=2C '0' as periodid=2C'DHIS-SYSTEM' as comment=2C '=
201308' as periodIsoDate=2C'dataelementname' as dataelementname=2C 'optionc=
omboid' as categoryoptioncomboname=2C ou.name as organisationunitname=2C co=
unt (psi.programinstanceid ) as value FROM programstageinstance as psi INNE=
R JOIN organisationunit ou on ou.organisationunitid=3Dpsi.organisationuniti=
d WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patien=
tid =3D pi.patientid and _pav.patientattributeid=3D280 AND p.organisationun=
itid in (0) AND _pav.value )=3D'Especial' ) GROUP BY ou.organisationunitid=
=2C ou.name</b><br><br>the error is generated when we edit the aggregation =
query=2C but it is don't generated with aggregation query that use the atti=
butes of patient that it is by default. (Sex).<br><br>Thanks=2C <br><br>ING=
. Helder Yesid Castrillon.<br>Secretar=EDa departamental de salud<br><br><b=

<div><hr id=3D"ecxstopSpelling">Date: Mon=2C 26 Aug 2013 09:21:39 -0500<b=
From: markodavidgm@gmail.com<br>To: dhis2-users@lists.launchpad.net<br>Su=

bject: [Dhis2-users] Aggregation Query Builder doesn't count<br><br><div di=
r=3D"ltr">Hello Friends.<div><br></div><div>After migrate to 2.12 version=
=2C the aggregation query builder doesn't aggregate the values in the data =
element. &nbsp=3BWe test with new data elements=2C simple queries but doesn=
't work. &nbsp=3B Maybe the new version has other parameters to aggregate t=
he 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>=
=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>=

--_47424454-041a-4e05-b53a-25738487c2ed_--