← Back to team overview

dhis2-devs team mailing list archive

[Bug 1415798] Re: aggregation does not escape ' from data element name

 

When adding data entry, was supposed to read "When adding a data
element"

-- 
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


References