← Back to team overview

dhis2-users team mailing list archive

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

 

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

Follow ups

References