=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
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=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
Thank you very much.=20
--=20
Regards=2C
Ing. Marko David Garcia M.
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=C1rea de Sistemas integrados de Informaci=F3n
Secretar=EDa de Salud Departamental del Cauca
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=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 =0A=
ยทยทยท
Subject: [Dhis2-users] Aggregation Query Builder doesn't count
_______________________________________________
=0A=
Mailing list: DHIS 2 Users in Launchpad
=0A=
Post to : dhis2-users@lists.launchpad.net
=0A=
Unsubscribe : DHIS 2 Users in Launchpad
=0A=
More help : ListHelp - Launchpad Help
=0A=
=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=
=
--_cb42dc16-9d27-47b8-bffa-265184a3b8a4_
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 =3B Ch=E2u=2C <br><br>Tha=
nks for you collaboration=2C today we could test these revision (11292) and=
it has worked very well.<br><br>regard.<br><br>Mg. Helder Yesid Castrillon=
.<br>=0A=
=0A=
Sistemas de informaci=F3n<br>Secretar=EDa departamental de salud del cauca.=
<br>Colombia.<br><br><br><div><hr id=3D"stopSpelling">CC: dhis2-users@lists=
.launchpad.net<br>From: tran.hispvietnam@gmail.com<br>Subject: Re: [Dhis2-u=
sers] Aggregation Query Builder doesn't count<br>Date: Sat=2C 31 Aug 2013 1=
0:14:28 +0700<br>To: helder_947@hotmail.com<br><br><div style=3D"">Hi Helde=
r=2C</div><div style=3D""><br></div><div style=3D"">This bug was fixed for =
only 1.12 version. For 2.13=2C we have a plan to improve it by using web-AP=
I. And I am working on it.</div><div style=3D""><br></div><div><span style=
=3D"">I tested this bug on demo server ( with revision =3B</span><span =
style=3D"background-color:rgba(255=2C 255=2C 255=2C 0)=3B">11292  =3Bin=
this morning)=2C it works fine. Can you help me to test it again ?</span><=
/div><div style=3D""><font face=3D"LiberationSansRegular=2C arial=2C sans-s=
erif"><span style=3D"line-height:25px=3B"><br></span></font><br>Best regard=
=2C</div><div style=3D""><br>On 30-08-2013=2C at 23:42=2C helder yesid cast=
rillon cobo <=3B<a href=3D"mailto:helder_947@hotmail.com">helder_947@hotm=
ail.com</a>>=3B wrote:<br><br></div><div style=3D"">=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<br>I downloaded DHIS 2.13-SNAPSHOT with revision 118=
46 from <a href=3D"DHIS2 App Hub; target=3D"_=
blank">DHIS2 App Hub to test=2C b=
ut =3B in this revision the error persist=2C also we tested in the demo=
of DHIS to discard errors in ours Data=2C obtaining the same error.<br><br=
<br><br><br>Mg. Helder Yesid Castrillon.<br>=0A=
=0A=
Sistemas de informaci=F3n<br>Secretar=EDa departamental de salud del cauca.=
<br><br><br><div><hr id=3D"ecxstopSpelling">From: <a href=3D"mailto:helder_=
947@hotmail.com">helder_947@hotmail.com</a><br>To: <a href=3D"mailto:tran.h=
ispvietnam@gmail.com">tran.hispvietnam@gmail.com</a><br>Date: Fri=2C 30 Aug=
2013 15:17:29 +0200<br>CC: <a href=3D"mailto:dhis2-users@lists.launchpad.n=
et">dhis2-users@lists.launchpad.net</a><br>Subject: Re: [Dhis2-users] Aggre=
gation Query Builder 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=
=0A=
--></style>=0A=
<div dir=3D"ltr">Ok=2C I tested with revisions 11245 and 11290 =3B but =
the error persist=2C today I downloaded Dhis the web site (<a href=3D"http:=
//www.dhis2.org/downloads" target=3D"_blank">Downloads - DHIS2
</a>)=2C however it is the same revision (11290)<br>How I download DHIS 2.1=
2 with revision 11291?.<br><br>Mg. Helder Yesid Castrillon.<br>=0A=
=0A=
Sistemas de informaci=F3n<br>Secretar=EDa departamental de salud del cauca.=
<br><br><br><div><hr id=3D"ecxstopSpelling">From: <a href=3D"mailto:tran.hi=
spvietnam@gmail.com">tran.hispvietnam@gmail.com</a><br>Date: Fri=2C 30 Aug =
2013 10:48:17 +0700<br>Subject: Re: [Dhis2-users] Aggregation Query Builder=
doesn't count<br>To: <a href=3D"mailto:helder_947@hotmail.com">helder_947@=
hotmail.com</a><br>CC: <a href=3D"mailto:markodavidgm@gmail.com">markodavid=
gm@gmail.com</a>=3B <a href=3D"mailto:dhis2-users@lists.launchpad.net">dhis=
2-users@lists.launchpad.net</a><br><br><div dir=3D"ltr">Hi Helder=2C<div><b=
</div><div>It's fixed for 2.12 with revision =3B11291. Please help me=
to re-test it on your side. Thank you.</div></div><div class=3D"ecxgmail_e=
xtra"><br clear=3D"all"><div>Best regards=2C<br>---------------------------=
---------------------<br>=0A=
=0A=
Ch=E2u Thu Tr=E2n =3B  =3B  =3B  =3B  =3B  =3B &nbs=
p=3B  =3B  =3B  =3B  =3B  =3B  =3B  =3B  =
=3B  =3B <br>HISP Viet Nam<br>Email: <a href=3D"mailto:tran.hispvietnam=
@gmail.com" target=3D"_blank">tran.hispvietnam@gmail.com</a></div>=0A=
<br><br><div class=3D"ecxgmail_quote">On Fri=2C Aug 30=2C 2013 at 3:49 AM=
=2C helder yesid castrillon cobo <span dir=3D"ltr"><=3B<a href=3D"mailto:=
helder_947@hotmail.com" target=3D"_blank">helder_947@hotmail.com</a>>=3B<=
/span> wrote:<br><blockquote class=3D"ecxgmail_quote" style=3D"border-left:=
1px #ccc solid=3Bpadding-left:1ex=3B">=0A=
=0A=
=0A=
=0A=
=0A=
<div><div dir=3D"ltr">It is not our case=2C all the formulas has apostroph =
(') in the values. We have identified that the bug is when we do aggregatio=
n query using the patients attributes created by us.<br><br><br><br>Mg. Hel=
der Yesid Castrillon.<br>=0A=
=0A=
Sistemas de informaci=F3n<br>Secretar=EDa departamental de salud del cauca.=
<br><br><br><br><div><hr>From: <a href=3D"mailto:tran.hispvietnam@gmail.com=
" target=3D"_blank">tran.hispvietnam@gmail.com</a><br>Date: Wed=2C 28 Aug 2=
013 15:39:52 +0700<div class=3D"ecxim">=0A=
=0A=
<br>Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count<br><=
/div>To: <a href=3D"mailto:markodavidgm@gmail.com" target=3D"_blank">markod=
avidgm@gmail.com</a><br>CC: <a href=3D"mailto:helder_947@hotmail.com" targe=
t=3D"_blank">helder_947@hotmail.com</a>=3B <a href=3D"mailto:dhis2-users@li=
sts.launchpad.net" target=3D"_blank">dhis2-users@lists.launchpad.net</a><di=
=0A=
=0A=
<div class=3D"h5"><br><br><div dir=3D"ltr">Hi Marko=2C<br><br>It works with=
formula [CA:43567] =3D 'Gender'. For formulas like this [CA:43567] =3D Gen=
der (Gender didn't put between apostroph )=2C formulas didn't work. So if y=
ou have any formula similar to the second case=2C please put value to compa=
re between apostroph (') . This bug will be fixed for 2.13 version as plan.=
<br>=0A=
=0A=
=0A=
=0A=
<br>Thank you=2C Marko.<br></div><div><br clear=3D"all"><div>Best regards=
=2C<br>------------------------------------------------<br>Ch=E2u Thu Tr=E2=
n =3B  =3B  =3B  =3B  =3B  =3B  =3B  =3B &n=
bsp=3B  =3B  =3B  =3B  =3B  =3B  =3B  =3B <br>H=
ISP Viet Nam<br>Email: <a href=3D"mailto:tran.hispvietnam@gmail.com" target=
=3D"_blank">tran.hispvietnam@gmail.com</a></div>=0A=
=0A=
=0A=
=0A=
=0A=
<br><br><div>On Tue=2C Aug 27=2C 2013 at 9:15 PM=2C Marko David Garcia Mu=
=F1oz <span dir=3D"ltr"><=3B<a href=3D"mailto:markodavidgm@gmail.com" tar=
get=3D"_blank">markodavidgm@gmail.com</a>>=3B</span> wrote:<br><blockquot=
e style=3D"border-left:1px #ccc solid=3Bpadding-left:1ex=3B">=0A=
=0A=
=0A=
=0A=
<div style=3D"word-wrap:break-word=3B">Thank you Tran.<div><br></div><div>"=
Regimen" is patient attribute created by Us=2C when we try to test the cond=
ition the system show the warning window.</div><div>For Example if we use "=
Genero" =3D Gender=2C or if we use the dataelement parameter ('210 - Dengue=
') the query works fine.</div>=0A=
=0A=
=0A=
=0A=
<div><br></div><div>Thank you very much.<br><div><br></div><div><=3BCaptu=
ra de pantalla 2013-08-27 a la(s) 8.52.00.png>=3B<br><div>=0A=
<div style=3D"text-indent:0px=3Bletter-spacing:normal=3Bfont-variant:normal=
=3Btext-align:-webkit-auto=3Bfont-style:normal=3Bfont-weight:normal=3Bline-=
height:normal=3Btext-transform:none=3Bfont-size:medium=3Bwhite-space:normal=
=3Bfont-family:Helvetica=3Bword-wrap:break-word=3Bword-spacing:0px=3B">=0A=
=0A=
=0A=
=0A=
<div style=3D"text-indent:0px=3Bletter-spacing:normal=3Bfont-variant:normal=
=3Btext-align:-webkit-auto=3Bfont-style:normal=3Bfont-weight:normal=3Bline-=
height:normal=3Btext-transform:none=3Bfont-size:medium=3Bwhite-space:normal=
=3Bfont-family:Helvetica=3Bword-wrap:break-word=3Bword-spacing:0px=3B">=0A=
=0A=
=0A=
=0A=
Cordialmente=2C<br><br>Ing. Marko David Garcia Mu=F1oz</div><div style=3D"t=
ext-indent:0px=3Bletter-spacing:normal=3Bfont-variant:normal=3Btext-align:-=
webkit-auto=3Bfont-style:normal=3Bfont-weight:normal=3Bline-height:normal=
=3Btext-transform:none=3Bfont-size:medium=3Bwhite-space:normal=3Bfont-famil=
y:Helvetica=3Bword-wrap:break-word=3Bword-spacing:0px=3B">=0A=
=0A=
=0A=
=0A=
Secretar=EDa Departamental de Salud del Cauca</div><div style=3D"text-inden=
t:0px=3Bletter-spacing:normal=3Bfont-variant:normal=3Btext-align:-webkit-au=
to=3Bfont-style:normal=3Bfont-weight:normal=3Bline-height:normal=3Btext-tra=
nsform:none=3Bfont-size:medium=3Bwhite-space:normal=3Bfont-family:Helvetica=
=3Bword-wrap:break-word=3Bword-spacing:0px=3B">=0A=
=0A=
=0A=
=0A=
=C1rea de Sistemas Integrados de Informaci=F3n</div><div style=3D"text-inde=
nt:0px=3Bletter-spacing:normal=3Bfont-variant:normal=3Btext-align:-webkit-a=
uto=3Bfont-style:normal=3Bfont-weight:normal=3Bline-height:normal=3Btext-tr=
ansform:none=3Bfont-size:medium=3Bwhite-space:normal=3Bfont-family:Helvetic=
a=3Bword-wrap:break-word=3Bword-spacing:0px=3B">=0A=
=0A=
=0A=
=0A=
Skype: marko_david<br><br><br></div></div>=0A=
</div>=0A=
<br><div><div>El 26/08/2013=2C a las 23:19=2C Tran Chau <=3B<a href=3D"ma=
ilto:tran.hispvietnam@gmail.com" target=3D"_blank">tran.hispvietnam@gmail.c=
om</a>>=3B escribi=F3:</div><div><div><br><blockquote><div dir=3D"ltr">=
=0A=
=0A=
Dear Marko and =3BHelder=2C<br><div><br></div><div>Could you please sen=
d to me the formula you created. I can try to test with this formula in my =
laptop.</div><div><br></div><div>Thank you.</div></div><div>=0A=
=0A=
=0A=
=0A=
<br clear=3D"all"><div>Best regards=2C<br>---------------------------------=
---------------<br>Ch=E2u Thu Tr=E2n =3B  =3B  =3B  =3B &nb=
sp=3B  =3B  =3B  =3B  =3B  =3B  =3B  =3B  =
=3B  =3B  =3B  =3B <br>HISP Viet Nam<br>Email: <a href=3D"mailt=
o:tran.hispvietnam@gmail.com" target=3D"_blank">tran.hispvietnam@gmail.com<=
/a></div>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
<br><br><div>On Tue=2C Aug 27=2C 2013 at 5:47 AM=2C helder yesid castrillon=
cobo <span dir=3D"ltr"><=3B<a href=3D"mailto:helder_947@hotmail.com" tar=
get=3D"_blank">helder_947@hotmail.com</a>>=3B</span> wrote:<br><blockquot=
e style=3D"border-left:1px #ccc solid=3Bpadding-left:1ex=3B">=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
<div><div dir=3D"ltr">sorry!!<br><br>SEX =3D gender<br>In spanish genero=2C=
sexo.<br><br>ING. Helder Yesid Castrillon.<br><div><br><br><br></div><div>=
<div><hr>From: <a href=3D"mailto:helder_947@hotmail.com" target=3D"_blank">=
helder_947@hotmail.com</a><br>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
To: <a href=3D"mailto:markodavidgm@gmail.com" target=3D"_blank">markodavidg=
m@gmail.com</a>=3B <a href=3D"mailto:dhis2-users@lists.launchpad.net" targe=
t=3D"_blank">dhis2-users@lists.launchpad.net</a><br>Date: Tue=2C 27 Aug 201=
3 00:43:56 +0200<br>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count</div><di=
<div><br><br>=0A=
=0A=
=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>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
<b>ERROR: syntax error at or near ")" at character 617<br>STATEMENT: SELECT=
'0' as dataelementid=2C '0' as categoryoptioncomboid=2C ou.organisationuni=
tid as sourceid=2C '0' as periodid=2C'DHIS-SYSTEM' as comment=2C '201308' a=
s periodIsoDate=2C'dataelementname' as dataelementname=2C 'optioncomboid' a=
s categoryoptioncomboname=2C <a href=3D"http://ou.name/" target=3D"_blank">=
ou.name</a> as organisationunitname=2C count (psi.programinstanceid ) as va=
lue FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.o=
rganisationunitid=3Dpsi.organisationunitid WHERE EXISTS ( SELECT * FROM pat=
ientattributevalue _pav WHERE _pav.patientid =3D pi.patientid and _pav.pati=
entattributeid=3D280 AND p.organisationunitid in (0) AND _pav.value )=3D'Es=
pecial' ) GROUP BY ou.organisationunitid=2C <a href=3D"http://ou.name/" tar=
get=3D"_blank">ou.name</a></b><br>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
<br>the error is generated when we edit the aggregation query=2C but it is =
don't generated with aggregation query that use the attibutes of patient th=
at it is by default. (Sex).<br><br>Thanks=2C <br><br>ING. Helder Yesid Cast=
rillon.<br>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
Secretar=EDa departamental de salud<br><br><br><div><hr>Date: Mon=2C 26 Aug=
2013 09:21:39 -0500<br>From: <a href=3D"mailto:markodavidgm@gmail.com" tar=
get=3D"_blank">markodavidgm@gmail.com</a><br>To: <a href=3D"mailto:dhis2-us=
ers@lists.launchpad.net" target=3D"_blank">dhis2-users@lists.launchpad.net<=
/a><br>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
Subject: [Dhis2-users] Aggregation Query Builder doesn't count<br><br><div =
dir=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.  =3BWe test with new data elements=2C simple queries but doesn=
't work.  =3B Maybe the new version has other parameters to aggregate t=
he values?.</div>=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
<div><br></div><div>Thank you very much.</div><div> =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=
=0A=
=0A=
=0A=
=0A=
=0A=
=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=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
</div>=0A=
</div></div>=0A=
<br>_______________________________________________=0A=
Mailing list: <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a>=0A=
Post to : <a href=3D"mailto:dhis2-users@lists.launchpad.net" target=3D"=
_blank">dhis2-users@lists.launchpad.net</a>=0A=
Unsubscribe : <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a>=0A=
More help : <a href=3D"https://help.launchpad.net/ListHelp" target=3D"_bl=
ank">https://help.launchpad.net/ListHelp</a></div> </div>=0A=
<br>_______________________________________________=0A=
Mailing list: <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a>=0A=
Post to : <a href=3D"mailto:dhis2-users@lists.launchpad.net" target=3D"=
_blank">dhis2-users@lists.launchpad.net</a>=0A=
Unsubscribe : <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a>=0A=
More help : <a href=3D"https://help.launchpad.net/ListHelp" target=3D"_bl=
ank">https://help.launchpad.net/ListHelp</a></div></div></div> <=
/div></div>=0A=
<br>_______________________________________________<br>=0A=
Mailing list: <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a><br>=0A=
Post to  =3B  =3B : <a href=3D"mailto:dhis2-users@lists.launchpad.n=
et" target=3D"_blank">dhis2-users@lists.launchpad.net</a><br>=0A=
Unsubscribe : <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a><br>=0A=
More help  =3B : <a href=3D"https://help.launchpad.net/ListHelp" target=
=3D"_blank">https://help.launchpad.net/ListHelp</a><br>=0A=
<br></blockquote></div><br></div>=0A=
</blockquote></div></div></div><br></div></div></div></blockquote></div><br=
</div></div></div></div> </div></div>=0A=
</blockquote></div><br></div></div> </div>=0A=
<br>_______________________________________________=0A=
Mailing list: <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a>=0A=
Post to : <a href=3D"mailto:dhis2-users@lists.launchpad.net">dhis2-user=
s@lists.launchpad.net</a>=0A=
Unsubscribe : <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a>=0A=
More help : <a href=3D"https://help.launchpad.net/ListHelp" target=3D"_bl=
ank">https://help.launchpad.net/ListHelp</a></div> </div>=0A=
</div></div> </div></body>
</html>=
--_cb42dc16-9d27-47b8-bffa-265184a3b8a4_--