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