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 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
