dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olatitle@xxxxxxxxx>]

Reopening this bug.

The SQL syntax generated for the create table statement does not handle
groupset names with spaces e.g. "Group Set A" would simply be converted
to a column with the name "Group Set A" which is not accepted in SQL. In
stead the column name should be Group_Set_A" or use some other smart way
of getting rid of the spaces in the names.

I got the following SQL for my test with the SL database, notice "Local
Council" as one of the column names:

CREATE TABLE orgunitgroupsetexclusivestructure ( 
organisationunitid INTEGER NOT NULL, 
Local Council VARCHAR (50), 
Mission VARCHAR (50), 
NGO VARCHAR (50), 
Ownership VARCHAR (50), 
Private VARCHAR (50), 
Public VARCHAR (50), 
Type VARCHAR (50), 
PRIMARY KEY ( organisationunitid ) );

(these group sets does not make sense to me as they look for like
groups, but the bug is still valid...)

Would also like to add that we need a similar table for exclusive data
element group sets.

-- 
Exclusive group set structure fails
https://bugs.launchpad.net/bugs/423949
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

Status in DHIS 2 - District Health Information Software: In Progress

Bug description:
Exclusive group set structure fails