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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 <[email protected]> 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 >>>> [email protected] <[email protected]> | [email protected] | Skype: >>>> prospertb >>>> >>>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <[email protected]> >>>> 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 < >>>>> [email protected]> 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 <[email protected] >>>>>> > 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 : [email protected] >>>>>>> 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 : [email protected] >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : [email protected] >>> 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 [email protected] >> <[email protected]> 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 [email protected] <[email protected]> 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-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
