dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

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.hispvietnam@xxxxxxxxx


On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo <
helder_947@xxxxxxxxxxx> wrote:

> sorry!!
>
> SEX = gender
> In spanish genero, sexo.
>
> ING. Helder Yesid Castrillon.
>
>
>
> ------------------------------
> From: helder_947@xxxxxxxxxxx
> To: markodavidgm@xxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
> 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: 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
>
> _______________________________________________ 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
>
> _______________________________________________
> 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
>
>