dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

Congrats, Helder...

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


On Mon, Sep 2, 2013 at 9:03 PM, helder yesid castrillon cobo <
helder_947@xxxxxxxxxxx> wrote:

> Hi  Châu,
>
> Thanks for you collaboration, today we could test these revision (11292)
> and it has worked very well.
>
> regard.
>
>
> Mg. Helder Yesid Castrillon.
> Sistemas de información
> Secretaría departamental de salud del cauca.
> Colombia.
>
>
> ------------------------------
> CC: dhis2-users@xxxxxxxxxxxxxxxxxxx
> From: tran.hispvietnam@xxxxxxxxx
>
> Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count
> Date: Sat, 31 Aug 2013 10:14:28 +0700
> To: helder_947@xxxxxxxxxxx
>
>
> Hi Helder,
>
> This bug was fixed for only 1.12 version. For 2.13, we have a plan to
> improve it by using web-API. And I am working on it.
>
> I tested this bug on demo server ( with revision 11292  in this morning),
> it works fine. Can you help me to test it again ?
>
>
> Best regard,
>
> On 30-08-2013, at 23:42, helder yesid castrillon cobo <
> helder_947@xxxxxxxxxxx> wrote:
>
> Hi,
> I downloaded DHIS 2.13-SNAPSHOT with revision 11846 from
> http://apps.dhis2.org/ci/job/dhis-web-2.12/  to test, but  in this
> revision the error persist, also we tested in the demo of DHIS to discard
> errors in ours Data, obtaining the same error.
>
>
>
>
> Mg. Helder Yesid Castrillon.
> Sistemas de información
> Secretaría departamental de salud del cauca.
>
>
> ------------------------------
> From: helder_947@xxxxxxxxxxx
> To: tran.hispvietnam@xxxxxxxxx
> Date: Fri, 30 Aug 2013 15:17:29 +0200
> CC: dhis2-users@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count
>
> Ok, I tested with revisions 11245 and 11290  but the error persist, today
> I downloaded Dhis the web site (http://www.dhis2.org/downloads), however
> it is the same revision (11290)
> How I download DHIS 2.12 with revision 11291?.
>
> Mg. Helder Yesid Castrillon.
> Sistemas de información
> Secretaría departamental de salud del cauca.
>
>
> ------------------------------
> From: tran.hispvietnam@xxxxxxxxx
> Date: Fri, 30 Aug 2013 10:48:17 +0700
> Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count
> To: helder_947@xxxxxxxxxxx
> CC: markodavidgm@xxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
>
> 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.
>
> <Captura de pantalla 2013-08-27 a la(s) 8.52.00.png>
>  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
>
>
>
>
>
>
> _______________________________________________ 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
>