dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Jose

Copying to devs list as there may be greater wisdom there :-)

I think your approach can work .. ie store your historical scores as
dataelement.

Regarding regenerating the formula, again I think you are right and will
have to resort to a database function as I can't think of an easy
workaround through the application and you really don't want to do these
manually.

Though I start to think that if you go down this route perhaps the
indicator becomes redundant.  You will have your formula as stored proc in
database and can probably use that to populate your "score" dataelement
directly.

Bob


On 14 July 2013 12:15, Jose Garcia Muñoz <josemp10@xxxxxxxxx> wrote:

>
> Hi guys,
>
> How are you doing?
>
> first at all, maybe I should send this email to the dev user list, if so,
> sorry about that and please feel free to resend it.
>
> I am dealing with several forms in DHIS2 with all its DE of the "trueOnly"
> type value. For each form, one final score is calculated depending on the
> number of questions answered by the users and one weight associated for
> each question. Of course, we have defined an indicator to calculate this
> value. But, what about when the number of questions (or the different
> weights) change along the time (so the formula needs to be redefined) and
> we still need to maintain the historical score of the "old" formulas?
>
> We were thinking about the possibility of creating a data element for each
> form to store the historical scores. Does it make sense? If so, the big
> challenge will be the connection of the indicator (when its value is
> calculated) with the Data Element. Some ideas about how could I deal with
> this? Create a trigger inside the database (with an 'on completion' event)?
>
> Best regards
> Jose
>