Yes, this query will give you category options, which I think should not be possible, but does seem to happen.
The specific issue I was referring to can be checked with this.. SELECT trim(name), count(*) from dataelementcategoryoption GROUP BY trim(name) HAVING COUNT(*) >1 Again, I have not checked the code to see if the category is actually trimmed or not, but I suspect it may be. Maybe Lars can comment as this workaround seems to be popping up in various places (Nigeria, Gambia that I know of). Regards, Jason 2011/8/19 Lars Helge Øverland <[email protected]> > I agree with Jason. Run this sql to check: > > > select categoryoptionid, ( > select count(categoryoptionid) from categories_categoryoptions where > categoryoptionid=cc.categoryoptionid ) > as categorycount from categories_categoryoptions as cc order by > categorycount desc; > > > > > > Lars >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
