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-us...@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-us...@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-us...@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.*
>
_______________________________________________
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

Reply via email to