dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

Hi Helder,

It's fixed for 2.12 with revision 11291. Please help me to re-test it on
your side. Thank you.

Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Fri, Aug 30, 2013 at 3:49 AM, helder yesid castrillon cobo <
helder_947@xxxxxxxxxxx> wrote:

> It is not our case, all the formulas has apostroph (') in the values. We
> have identified that the bug is when we do aggregation query using the
> patients attributes created by us.
>
>
>
> Mg. Helder Yesid Castrillon.
> Sistemas de información
> Secretaría departamental de salud del cauca.
>
>
>
> ------------------------------
> From: tran.hispvietnam@xxxxxxxxx
> Date: Wed, 28 Aug 2013 15:39:52 +0700
>
> Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count
> To: markodavidgm@xxxxxxxxx
> CC: helder_947@xxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
>
>
> Hi Marko,
>
> It works with formula [CA:43567] = 'Gender'. For formulas like this
> [CA:43567] = Gender (Gender didn't put between apostroph ), formulas didn't
> work. So if you have any formula similar to the second case, please put
> value to compare between apostroph (') . This bug will be fixed for 2.13
> version as plan.
>
> Thank you, Marko.
>
> Best regards,
> ------------------------------------------------
> Châu Thu Trân
> HISP Viet Nam
> Email: tran.hispvietnam@xxxxxxxxx
>
>
> On Tue, Aug 27, 2013 at 9:15 PM, Marko David Garcia Muñoz <
> markodavidgm@xxxxxxxxx> wrote:
>
> Thank you Tran.
>
> "Regimen" is patient attribute created by Us, when we try to test the
> condition the system show the warning window.
> For Example if we use "Genero" = Gender, or if we use the dataelement
> parameter ('210 - Dengue') the query works fine.
>
> Thank you very much.
>
>
>  Cordialmente,
>
> Ing. Marko David Garcia Muñoz
> Secretaría Departamental de Salud del Cauca
> Área de Sistemas Integrados de Información
> Skype: marko_david
>
>
>
> El 26/08/2013, a las 23:19, Tran Chau <tran.hispvietnam@xxxxxxxxx>
> escribió:
>
> 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
>
>
>
>
>