dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #35409
[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