dhis2-devs team mailing list archive

[johansa@xxxxxxxxxx]

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and
the historical data is too poor to be used for calculation of such ranges
yet. Still, there have been some instances of really bad typos, such as
775 instead of 75. Most entries (maybe around 98%) are below 100, so as a
temporary shield we would like to set default ranges as 0-99 (to catch all
three-digit entries). Any clue on how to do this? Would running a query
directly on the database solve it, and what would that query look like?
(sorry, but not good at SQL)

Johan