← Back to team overview

dhis2-devs team mailing list archive

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

 

Excellent - thanks Lars!

On Thu, Dec 15, 2016 at 4:28 AM, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

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

References