← Back to team overview

dhis2-devs team mailing list archive

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

 

This should be back-ported to 2.25 now.

https://jira.dhis2.org/browse/DHIS2-209

Lars


On Tue, Dec 13, 2016 at 5:15 PM, Lorill Crees <lcrees@xxxxxxxxxx> wrote:

> 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
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>

Follow ups

References