← Back to team overview

dhis2-users team mailing list archive

Re: Delete Validation Rules


Hi Em

I'm not sure if there is any UI for deleting validation results, but you
can do it yourself in the database.

The validationresults are located in the table "validationresult", and it
has a column called "validationruleid" which links to your validation rules.

So you need to find that validation rule in the "validationrule" table, and
use that "validationruleid" to delete the correct rows from the
"validationresult" table.

"DELETE FROM validationresult WHERE validationruleid=??"

This does sound like a bug though, so please file one in JIRA

Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo

On Tue, Aug 7, 2018 at 5:07 PM, Em Le Hong <em.hispvietnam@xxxxxxxxx> wrote:

> Dear all,
> DHIS 2.29
> I try to delete a validation rule on my database but the system response a
> message:
> Could not delete due to association with another object: ValidationResult
> This mean we need to delete Validation Result before delete Validation Rule
> Does anyone know how to delete Validation Result, if you don't mind please
> share.
> Thanks,
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

Follow ups