Dear Marko and Helder, Could you please send to me the formula you created. I can try to test with this formula in my laptop.
Thank you. Best regards, ------------------------------------------------ Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo < helder_...@hotmail.com> wrote: > sorry!! > > SEX = gender > In spanish genero, sexo. > > ING. Helder Yesid Castrillon. > > > > ------------------------------ > From: helder_...@hotmail.com > To: markodavi...@gmail.com; dhis2-users@lists.launchpad.net > Date: Tue, 27 Aug 2013 00:43:56 +0200 > Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count > > > 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 > > _______________________________________________ > 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
