dhis2-users team mailing list archive

[helder yesid castrillon cobo <helder_947@xxxxxxxxxxx>]

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