dhis2-users team mailing list archive

[Manaf Abthul <drmanaf79@xxxxxxxxx>]

Hi sumudu,

It is working, testing is successful on Version:2.14 Build revision:13826.

I have checked for number of Asthma patient less than 12yrs. The age
attribute is patient attribute.

Os: Win7
MySQL database


On 29 March 2014 19:04, sumudu weerasinghe <sumuduw00@xxxxxxxxx> wrote:

> Dear all,
> I am trying customization of tracker for mental health information system
> in Sri Lanka.
> I want to calculate " number of patient <65 years"
>
>    - *Age* is a attribute - value type - Age(Years)
>    - I made aggregate query builder: [CA:1301]<65
>    - test condition shows Run failed
>    - error generate in catalina out is as follows
>
>
> *(DefaultUserAuditService.java
> [http-apr-8084-exec-7])org.springframework.jdbc.BadSqlGrammarException:
> StatementCallback; bad SQL grammar [SELECT '0' as dataelementid, '0' as
> categoryoptioncomboid, '0' as attributeoptioncomboid, ou.organisationunitid
> as sourceid, '0' as periodid,'aggregated_from_tracker' as comment, '201403'
> as periodIsoDate,'dataelementname' as dataelementname, 'optioncomboid' as
> categoryoptioncomboname, ou.name <http://ou.name> as organisationunitname,
> count(distinct(pi.patientid)) as value FROM  programinstance as pi INNER
> JOIN patient p on p.patientid=pi.patientid  INNER JOIN organisationunit ou
> ON ou.organisationunitid=p.organisationunitid  WHERE  EXISTS (   SELECT *
> FROM patientattributevalue _pav  WHERE _pav.patientid=pi.patientid  AND
> _pav.patientattributeid=1301 AND _pav.value  < 65 ) GROUP BY
> ou.organisationunitid, ou.name <http://ou.name>]; nested exception is
> org.postgresql.util.PSQLException: ERROR: operator does not exist:
> character varying < integer  Hint: No operator matches the given name and
> argument type(s). You might need to add explicit type casts.*
>
>
>
>
>    - This sql was able to correct by casting as follows
>
> * .....AND _pav.patientattributeid=1301 AND Cast(_pav.value as integer)  <
> 65 ) GROUP BY ou.organisationunitid, ou.name......*
>
> I am using
>
>    - dhis 2.14
>    - Build revision:13832
>    - Database type: PostgreSQL
>    - OS name:Windows 7
>    - OS architecture:x86
>
> Are there any error in my method of test ??
> I will attach screen shots and log file.
>
> Regards,
> Sumudu
>
>
>  --
> You received this message because you are subscribed to the Google Groups
> "DHIS_BMI4" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dhis_bmi4+unsubscribe@xxxxxxxxxxxxxxxx.
> For more options, visit https://groups.google.com/d/optout.
>

Attachment: agg.jpg
Description: JPEG image