dhis2-users team mailing list archive

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

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 <nyembwe@xxxxxxxxx> 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 <
> jason.p.pickering@xxxxxxxxx> 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 <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
>>
>
>
>
> --
> *Carlos Nyembwe*
> *Informaticien*
>
> *Skype: carloscnk1*
> *Téléphone: (+243)813166381 <%28%2B243%29813166381>*
> *URL: *www.linkedin.com/in/carloscnk
>



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