dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Basically, you need to add rows to the minmaxdataelement tabls, which means
a bunch of INSERT statements. I can try to generate it.

Knut

On Tue, May 19, 2009 at 5:06 PM, <johansa@xxxxxxxxxx> wrote:

> 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
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Cheers,
Knut Staring