dhis2-devs team mailing list archive

[Olav P <1415798@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

When adding data entry, ' is allowed in the name (example "Alzheimer's
disease"). However, the tracker => aggregate aggregation queries fails
if one of the target/aggregate data elements have ' in the name:

SELECT '2188' as dataelementid, '1873' as categoryoptioncomboid, '16' as
attributeoptioncomboid, ou.organisationunitid as sourceid, '1453' as
periodid,'aggregated_from_tracker' as storedby, '20150101' as
periodIsoDate,[THIS WILL BREAK=>]'Alzheimer's disease, dementias' as
dataelementname, '(Male, ≥ 95 years)' as categoryoptioncomboname,
ou.name as organisationunitname,  count(psi.programinstanceid) as value
FROM  programinstance as pi ... etc

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1415798

Title:
  aggregation does not escape ' from data element name

Status in DHIS 2:
  New

Bug description:
  When adding data entry, ' is allowed in the name (example "Alzheimer's
  disease"). However, the tracker => aggregate aggregation queries fails
  if one of the target/aggregate data elements have ' in the name:

  SELECT '2188' as dataelementid, '1873' as categoryoptioncomboid, '16'
  as attributeoptioncomboid, ou.organisationunitid as sourceid, '1453'
  as periodid,'aggregated_from_tracker' as storedby, '20150101' as
  periodIsoDate,[THIS WILL BREAK=>]'Alzheimer's disease, dementias' as
  dataelementname, '(Male, ≥ 95 years)' as categoryoptioncomboname,
  ou.name as organisationunitname,  count(psi.programinstanceid) as
  value FROM  programinstance as pi ... etc

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1415798/+subscriptions