dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Carlos,
The only real way to do this at the moment is to remove the data values
from the database with SQL.

So, something like

DELETE FROM datavalue where sourceid = XXXXX;

where XXXXXX is the organisationunitid of the orgunit you wish to delete.

This statement will permanently delete all data associated with the orgunit
you wish to remove.

Just be sure, obviously, to ensure you have a backup of your database, and
that the SQL which you develop actually does what you want it to!

Regards,
Jason


On Mon, Jun 15, 2015 at 12:23 PM, Carlos Nyembwe <nyembwe@xxxxxxxxx> wrote:

>
> Hi all,
>
> I have a problem with OrgUnits, I want to delete a OrgUnit that no longer
> serves in the system but I know that this message which appears OrgUnit
> means that this is linked to the data but as I made my manipulations front
> end, and I am obliged to remove, then how?
>
> who can help me on this?
>
> thank you
>
>
> --
> *[image: Inline image 1]Carlos Nyembwe*
> *Informaticien*
>
> *Skype: carloscnk1*
> *Téléphone: (+243)813166381 <%28%2B243%29813166381>*
> *URL: *www.linkedin.com/in/carloscnk
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049