Proposed change in OrganisationUnitGroupSet - OrganisationUnitGroup model

Support - Assistance technique
1

Hi,

just wanted to propose a change to make the OrganisationUnitGroupSet - OrganisationUnitGroup association one-to-many. The purposes are

  • it will conform to the DataElement/IndicatorGroupSet model and make things consistent

  • it will conform to the Dimension - DimensionOption abstraction and improve how OrgunitGroupSet can be used in analysis in terms of dimensionality

Any objections?

If someone has groups belonging to more than one group set that will have to be changed. To verify it one can run a query something like:

select distinct orgunitgroupid, count(orgunitgroupid)
from orgunitgroupsetmembers
group by orgunitgroupsetid, orgunitgroupid;

Lars

2

Will implement this.

···

2010/1/14 Lars Helge Øverland larshelge@gmail.com

Hi,

just wanted to propose a change to make the OrganisationUnitGroupSet - OrganisationUnitGroup association one-to-many. The purposes are

  • it will conform to the DataElement/IndicatorGroupSet model and make things consistent

  • it will conform to the Dimension - DimensionOption abstraction and improve how OrgunitGroupSet can be used in analysis in terms of dimensionality

Any objections?

If someone has groups belonging to more than one group set that will have to be changed. To verify it one can run a query something like:

select distinct orgunitgroupid, count(orgunitgroupid)
from orgunitgroupsetmembers
group by orgunitgroupsetid, orgunitgroupid;

Lars