In that case, you will need to delete the data using the user interface. Currently, there is no way to delete an orgunit which has data associated with it, without deleting all of the data from that orgunit first.
On Mon, Jun 15, 2015 at 1:17 PM, Carlos Nyembwe <[email protected]> wrote: > Thanks, but i kown that but, I don't use back end, I'm using front end. > now, how can I execute the SQL? > > > On Mon, Jun 15, 2015 at 11:38 AM, Jason Pickering < > [email protected]> wrote: > >> 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 <[email protected]> >> 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 : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jason P. Pickering >> email: [email protected] >> tel:+46764147049 >> > > > > -- > *Carlos Nyembwe* > *Informaticien* > > *Skype: carloscnk1* > *Téléphone: (+243)813166381 <%28%2B243%29813166381>* > *URL: *www.linkedin.com/in/carloscnk > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
