Thanks Jason I totaly agree with you there is need to explore all options to reuse the cateories and even data elements. regards
On Wednesday, August 10, 2011, Jason Pickering <[email protected]> wrote: > Dear DHIS2 devs, > While considering the email sent to the users list this morning (which > is a problem I have come up against several time) I wanted to > experiment with the possible re-use of category options across > categories. With a bit of SQL applied to the database, I was able to > "reuse" a category option between two separate categories. One age > group > was defined as 0-4, >5 and the other as 0-4,5-10, 11-15. Note the > re-use of the "0-4" category option between two seperate categories. > These two separate age categories were applied to a category > combination, and then applied to a dataset. I was able to enter data > for a test organisation unit and time period. > > This leads me to beleive there is nothing wrong with the model, which > would not allow re-use of category options between categories, but > rather, it seems to be design issue which > 1) is not properly enforced because the restriction of a category > option to a single category seems to be rather easily evaded > or 2) should be relaxed/improved to allow the re-use of category > options between categories. > > Attached is the sample database (Postgres backup) which I created > during this experiment. Not sure by any means that everything works, > but it would be interesting to get comments on this issue, which has > been raised several times. > > Best regards, > Jason > -- Samuel Cheburet Ministry Of Health P.O. Box 20781 Nairobi, Kenya Mobile- 0721624338 *Don't Compromise The Quality! Don't Risk It! apply Available Standards to Achieve Your/organizational Goal.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
