← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] can't delete data element

 

Thanks Lars.

On Tue, Dec 13, 2016 at 8:10 AM, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

> Hi Lorill,
>
> this is done in master. Issue here:
>
> https://jira.dhis2.org/browse/DHIS2-209
>
> Will see if it can be back-ported.
>
> Lars
>
>
> On Tue, Dec 13, 2016 at 4:58 PM, Lorill Crees <lcrees@xxxxxxxxxx> wrote:
>
>> Hi Lars,
>>
>> Just following up on progress with this. Do you have an ETA on when this
>> will be available in 2.25?
>>
>> Thanks!
>>
>> Lorill
>>
>> On Fri, Nov 18, 2016 at 10:11 AM, Lorill Crees <lcrees@xxxxxxxxxx> wrote:
>>
>>> Great, thanks Lars!
>>>
>>> On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland <lars@xxxxxxxxx>
>>> wrote:
>>>
>>>>
>>>> Sure - will keep you posted - we will get it done in a few weeks time.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>> On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees <lcrees@xxxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Thanks Lars. Yes - keeping it on a data element will work for us.
>>>>>
>>>>> Could you please let me know when this is complete for us to try out?
>>>>> Or let me know the issue so I can track it?
>>>>>
>>>>> Thanks for accommodating this functionality - much appreciated!
>>>>>
>>>>> On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland <lars@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees <lcrees@xxxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Lars,
>>>>>>>
>>>>>>> That functionality would be what we need. Is this something that you
>>>>>>> could backport to 2.25?
>>>>>>>
>>>>>>>
>>>>>> Okay we can work on that. I have written an issue. Yes I think we can
>>>>>> back-port to 2.25.
>>>>>>
>>>>>>
>>>>>>> Also wondering if it would be possible to prune for a Data Set? That
>>>>>>> would reduce the amount of API calls as our end goal is to delete the Data
>>>>>>> Set itself.
>>>>>>>
>>>>>>>
>>>>>> I think we will keep it on data element - don't want to take this too
>>>>>> far. I guess you could chain API calls for this without too much hassle.
>>>>>>
>>>>>> best regards,
>>>>>>
>>>>>> Lars
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Let me know. Thanks,
>>>>>>>
>>>>>>> Lorill
>>>>>>>
>>>>>>> On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland <lars@xxxxxxxxx
>>>>>>> > wrote:
>>>>>>>
>>>>>>>> Sorry Lorill, I misread your question.
>>>>>>>>
>>>>>>>> No we haven't changed the policy that data element can be deleted
>>>>>>>> if data value audits exist.
>>>>>>>>
>>>>>>>> We recently implemented a feature for pruning
>>>>>>>> <https://dhis2.github.io/dhis2-docs/master/en/developer/html/webapi_maintenance.html>
>>>>>>>> data (including approval records, data set completeness records, data value
>>>>>>>> audits and data values) for organisation unit units.
>>>>>>>>
>>>>>>>> /api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>
>>>>>>>>
>>>>>>>> We could implement something similar for data elements.
>>>>>>>>
>>>>>>>>
>>>>>>>> Lars
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees <lcrees@xxxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi Lars,
>>>>>>>>>
>>>>>>>>> Thanks for the quick reply. Does this mean if we soft delete all
>>>>>>>>> data values associated with a data element we will then be able to hard
>>>>>>>>> delete the data element?
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>>
>>>>>>>>> Lorill
>>>>>>>>>
>>>>>>>>> On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland <
>>>>>>>>> lars@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> Hi Lorill,
>>>>>>>>>>
>>>>>>>>>> in 2.25 we introduced "soft data value" delete, meaning that in
>>>>>>>>>> the database we simply mark data values as deleted using the "deleted"
>>>>>>>>>> property (this is transparent to the users). This means that foreign key
>>>>>>>>>> constraints from data value audit values should not be a problem anymore.
>>>>>>>>>> Let us know if that solves it.
>>>>>>>>>>
>>>>>>>>>> regards,
>>>>>>>>>>
>>>>>>>>>> Lars
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees <lcrees@xxxxxxxxxx>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi,
>>>>>>>>>>>
>>>>>>>>>>> We have a long standing request to allow users of our custom
>>>>>>>>>>> DHIS 2 app to delete specific Data Sets and all corresponding data elements
>>>>>>>>>>> and values. We need to do this via the API.
>>>>>>>>>>>
>>>>>>>>>>> It seems the only thing preventing us from doing this now is the
>>>>>>>>>>> deletion of datavalueaudit records. Is there any plan to allow
>>>>>>>>>>> deletion of datavalueaudit records via the API? Or to remove
>>>>>>>>>>> dependencies from the datavalueaudit records so they can be standalone and
>>>>>>>>>>> not prevent the deletion of the corresponding data elements?
>>>>>>>>>>>
>>>>>>>>>>> Thanks,
>>>>>>>>>>>
>>>>>>>>>>> Lorill
>>>>>>>>>>>
>>>>>>>>>>> On Thu, Nov 17, 2016 at 11:37 PM, channara rin <
>>>>>>>>>>> rin.channara@xxxxxxxxx> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> YES,
>>>>>>>>>>>> thank you for reminding...
>>>>>>>>>>>>
>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> 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
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Lorill Crees
>>>>>>>>>>> Project Leader / Senior Developer
>>>>>>>>>>> 2Paths Solutions Ltd. <http://www.2paths.com>
>>>>>>>>>>>
>>>>>>>>>>> lcrees@xxxxxxxxxx
>>>>>>>>>>> skype: lorill2paths
>>>>>>>>>>> (604) 689-4123 x 15
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> 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
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Lars Helge Øverland
>>>>>>>>>> Lead developer, DHIS 2
>>>>>>>>>> University of Oslo
>>>>>>>>>> Skype: larshelgeoverland
>>>>>>>>>> lars@xxxxxxxxx
>>>>>>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Lorill Crees
>>>>>>>>> Project Leader / Senior Developer
>>>>>>>>> 2Paths Solutions Ltd. <http://www.2paths.com>
>>>>>>>>>
>>>>>>>>> lcrees@xxxxxxxxxx
>>>>>>>>> skype: lorill2paths
>>>>>>>>> (604) 689-4123 x 15
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Lars Helge Øverland
>>>>>>>> Lead developer, DHIS 2
>>>>>>>> University of Oslo
>>>>>>>> Skype: larshelgeoverland
>>>>>>>> lars@xxxxxxxxx
>>>>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Lorill Crees
>>>>>>> Project Leader / Senior Developer
>>>>>>> 2Paths Solutions Ltd. <http://www.2paths.com>
>>>>>>>
>>>>>>> lcrees@xxxxxxxxxx
>>>>>>> skype: lorill2paths
>>>>>>> (604) 689-4123 x 15
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Lars Helge Øverland
>>>>>> Lead developer, DHIS 2
>>>>>> University of Oslo
>>>>>> Skype: larshelgeoverland
>>>>>> lars@xxxxxxxxx
>>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Lorill Crees
>>>>> Project Leader / Senior Developer
>>>>> 2Paths Solutions Ltd. <http://www.2paths.com>
>>>>>
>>>>> lcrees@xxxxxxxxxx
>>>>> skype: lorill2paths
>>>>> (604) 689-4123 x 15
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Lars Helge Øverland
>>>> Lead developer, DHIS 2
>>>> University of Oslo
>>>> Skype: larshelgeoverland
>>>> lars@xxxxxxxxx
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>>>
>>>
>>>
>>> --
>>> Lorill Crees
>>> Project Leader / Senior Developer
>>> 2Paths Solutions Ltd. <http://www.2paths.com>
>>>
>>> lcrees@xxxxxxxxxx
>>> skype: lorill2paths
>>> (604) 689-4123 x 15 <(604)%20689-4123>
>>>
>>
>>
>>
>> --
>> Lorill Crees
>> Project Leader / Senior Developer
>> 2Paths Solutions Ltd. <http://www.2paths.com>
>>
>> lcrees@xxxxxxxxxx
>> skype: lorill2paths
>> (604) 689-4123 x 15 <(604)%20689-4123>
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>


-- 
Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd. <http://www.2paths.com>

lcrees@xxxxxxxxxx
skype: lorill2paths
(604) 689-4123 x 15

Follow ups

References