dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

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