dhis2-devs team mailing list archive

["jason.p.pickering" <676817@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The orgunitstructure table contains a large number of zeros, that should actually be NULLS. 
orgunitid, level, idlevel1, idlevel2, idlevel3,idlevel4,idlevel5, idlevel6,idlevel6,idlevel8
..
3839;1;3839;0;0;0;0;0;0;0
3840;3;3839;3832;3840;0;0;0;0;0
3841;3;3839;3832;3841;0;0;0;0;0
..

These zeroes do not refer to any particular orgunit and should be NULL.
I believe prior to 2.0.5 the values were null.

** Affects: dhis2
     Importance: Undecided
     Assignee: Hieu Duy Dang (hieu-hispvietnam)
         Status: Confirmed

** Changed in: dhis2
     Assignee: (unassigned) => Hieu Duy Dang (hieu-hispvietnam)

** Changed in: dhis2
       Status: New => Confirmed

-- 
orgunitstructure nulls are zeros
https://bugs.launchpad.net/bugs/676817
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: Confirmed

Bug description:
The orgunitstructure table contains a large number of zeros, that should actually be NULLS. 
orgunitid, level, idlevel1, idlevel2, idlevel3,idlevel4,idlevel5, idlevel6,idlevel6,idlevel8
..
3839;1;3839;0;0;0;0;0;0;0
3840;3;3839;3832;3840;0;0;0;0;0
3841;3;3839;3832;3841;0;0;0;0;0
..

These zeroes do not refer to any particular orgunit and should be NULL. I believe prior to 2.0.5 the values were null.