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

Excellent - thanks Lars! On Thu, Dec 15, 2016 at 4:28 AM, Lars Helge Øverland 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 wrote: > >> Thanks Lars. >> >> On Tue, Dec 13, 2016 at 8:10 A

Re: [Dhis2-devs] [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 wrote: > Thanks Lars. > > On Tue, Dec 13, 2016 at 8:10 AM, Lars Helge Øverland > wrote: > >> Hi Lorill, >> >> this is done in master. Issue here: >> >> https://j

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

Thanks Lars. On Tue, Dec 13, 2016 at 8:10 AM, Lars Helge Øverland 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 wrote: > >> Hi Lars, >> >

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

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 wrote: > Hi Lars, > > Just following up on progress with this. Do you have an ETA on when this > will be available in

Re: [Dhis2-devs] [Dhis2-users] 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 wrote: > Great, thanks Lars! > > On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland > wrote: > >> >> Sure - will keep

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

Great, thanks Lars! On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland 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 wrote: > >> Thanks Lars. Yes - keeping it on a data element will

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

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

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

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

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

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees 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 possibl

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

Hi Lars, That functionality would be what we need. Is this something that you could backport 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. Let me know. Thanks, Lorill On Fri,

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

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 data (including approval records

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

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 u

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

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 wrote: > Hi Lorill, > > in 2.25 we introduced "soft da

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

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 an

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

YES, thank you for reminding... ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp

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

Thanks Knutvery important. On 18 November 2016 at 09:35, Knut Staring wrote: > This should be obvious, but better to remind people one time too much: > If you decide to run DELETE queries, please always remember to first do a > backup (pg_dump). > > On Nov 18, 2016 8:27 AM, "channara rin" w

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

This should be obvious, but better to remind people one time too much: If you decide to run DELETE queries, please always remember to first do a backup (pg_dump). On Nov 18, 2016 8:27 AM, "channara rin" wrote: > Note thank you > > On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman wrote: > >> Yes

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

ohh,i see... but sql script can only run on server? cannot from client side? On Fri, Nov 18, 2016 at 2:08 PM, Ant Snyman wrote: > Hi Channara, > There is also a table called datavalueaudit which also contains a > reference to the dataelementid. The record should also be deleted from this > table

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

Note thank you On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman wrote: > Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS - > data administration) but you cannot update or delete using SQLVIEW, so in > this case you would have to do it in the "back-end". What you could do to

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

Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS - data administration) but you cannot update or delete using SQLVIEW, so in this case you would have to do it in the "back-end". What you could do to make sure is use SQLVIEW to see if that dataelementid exists in the datavalueau

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

Hi Channara, There is also a table called datavalueaudit which also contains a reference to the dataelementid. The record should also be deleted from this table, I normally do it through sql script, not sure if deleting a datavalue from the UI will also remove the datavalueaudit record. Regards Ant

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

yes, my DE use cate-combo and group. so after remove group, i can delete? On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT wrote: > Hi Channara, > > Did you assign it an option set or cat-comb or grouped it in a group or > even assigned it to a dataset or program, > > You have to check all these be

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

Hi Channara, Did you assign it an option set or cat-comb or grouped it in a group or even assigned it to a dataset or program, You have to check all these before deleting it. Regards Prosper Behumbiize, MPH DHIS2 Implementation| HISP Uganda/University Of Oslo +256 752 751 776 | +256 776 139 139

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

dear friend, i created new dataset and put only data element want to delete and then go through to delete data value already. but i still see the message like below: [image: Inline image 1] On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta wrote: > Hi Channara, > > You would have to delete all the

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

Hi Channara, You would have to delete all the values associated with that DE first. On Fri, Nov 18, 2016 at 9:43 AM, channara rin wrote: > dear all, > do you know how to delete data element that we already used input data > value? > > regards, > channara > >