Congrats, Helder... Best regards, ------------------------------------------------ Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com
On Mon, Sep 2, 2013 at 9:03 PM, helder yesid castrillon cobo < helder_...@hotmail.com> 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@lists.launchpad.net > From: tran.hispviet...@gmail.com > > Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count > Date: Sat, 31 Aug 2013 10:14:28 +0700 > To: helder_...@hotmail.com > > > 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_...@hotmail.com> 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_...@hotmail.com > To: tran.hispviet...@gmail.com > Date: Fri, 30 Aug 2013 15:17:29 +0200 > CC: dhis2-users@lists.launchpad.net > 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.hispviet...@gmail.com > Date: Fri, 30 Aug 2013 10:48:17 +0700 > Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count > To: helder_...@hotmail.com > CC: markodavi...@gmail.com; dhis2-users@lists.launchpad.net > > 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.hispviet...@gmail.com > > > On Fri, Aug 30, 2013 at 3:49 AM, helder yesid castrillon cobo < > helder_...@hotmail.com> 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.hispviet...@gmail.com > Date: Wed, 28 Aug 2013 15:39:52 +0700 > > Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count > To: markodavi...@gmail.com > CC: helder_...@hotmail.com; dhis2-users@lists.launchpad.net > > > 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.hispviet...@gmail.com > > > On Tue, Aug 27, 2013 at 9:15 PM, Marko David Garcia Muñoz < > markodavi...@gmail.com> 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.hispviet...@gmail.com> > 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.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 >
_______________________________________________ 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
