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" <rin.chann...@gmail.com> wrote: > Note thank you.... > > On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman <a...@hisp.org> 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 >> make sure is use SQLVIEW to see if that dataelementid exists in the >> datavalueaudit table. Something like "select * from datavalueaudit where >> dataelementid = .......... ". >> >> Regards >> >> Ant Snyman >> >> On 18 November 2016 at 09:10, channara rin <rin.chann...@gmail.com> >> wrote: >> >>> 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 <a...@hisp.org> 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, I normally do it through sql script, not sure if deleting a >>>> datavalue from the UI will also remove the datavalueaudit record. >>>> Regards >>>> Ant Snyman >>>> >>>> >>>> On 18 November 2016 at 06:38, channara rin <rin.chann...@gmail.com> >>>> wrote: >>>> >>>>> 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 <ptb3...@gmail.com> >>>>> 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 before deleting it. >>>>>> >>>>>> Regards >>>>>> >>>>>> Prosper Behumbiize, MPH >>>>>> DHIS2 Implementation| HISP Uganda/University Of Oslo >>>>>> +256 752 751 776 | +256 776 139 139 >>>>>> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype: >>>>>> prospertb >>>>>> >>>>>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <rin.chann...@gmail.com >>>>>> > wrote: >>>>>> >>>>>>> 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 < >>>>>>> shurajitdu...@gmail.com> wrote: >>>>>>> >>>>>>>> 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 < >>>>>>>> rin.chann...@gmail.com> wrote: >>>>>>>> >>>>>>>>> dear all, >>>>>>>>> do you know how to delete data element that we already used input >>>>>>>>> data value? >>>>>>>>> >>>>>>>>> regards, >>>>>>>>> channara >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Shurajit Dutta >>>>>>>> Health Information Consultant >>>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : dhis2-users@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> *Ant Snyman* >>>> >>>> *Cell: 0824910449* >>>> >>>> *Landline: 028 2713242* >>>> >>>> >>>> Health Information Systems Program - SA >>>> >>>> *This message and any attachments are subject to a disclaimer published >>>> at http://www.hisp.org/policies.html#comms_disclaimer >>>> <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the >>>> disclaimer before opening any attachment or taking any other action in >>>> terms of this electronic transmission. If you cannot access the >>>> disclaimer, kindly send an email to disclai...@hisp.org >>>> <disclai...@hisp.org> and a copy will be provided to you. By replying to >>>> this e-mail or opening any attachment you agree to be bound by the >>>> provisions of the disclaimer.* >>>> >>> >>> >> >> >> -- >> >> *Ant Snyman* >> >> *Cell: 0824910449* >> >> *Landline: 028 2713242* >> >> >> Health Information Systems Program - SA >> >> *This message and any attachments are subject to a disclaimer published >> at http://www.hisp.org/policies.html#comms_disclaimer >> <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the >> disclaimer before opening any attachment or taking any other action in >> terms of this electronic transmission. If you cannot access the >> disclaimer, kindly send an email to disclai...@hisp.org >> <disclai...@hisp.org> and a copy will be provided to you. By replying to >> this e-mail or opening any attachment you agree to be bound by the >> provisions of the disclaimer.* >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp