dhis2-users team mailing list archive

[channara rin <rin.channara@xxxxxxxxx>]

Note thank you....

On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman <ant@xxxxxxxx> 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.channara@xxxxxxxxx> 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 <ant@xxxxxxxx> 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.channara@xxxxxxxxx>
>>> 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 <ptb3000@xxxxxxxxx> 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
>>>>> prosper@xxxxxxxxxxxxxx <ptb3000@xxxxxxxxx> | prosper@xxxxxxxxx | Skype:
>>>>> prospertb
>>>>>
>>>>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <rin.channara@xxxxxxxxx>
>>>>> 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 <
>>>>>> shurajitdutta@xxxxxxxxx> 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.channara@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> 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 disclaimer@xxxxxxxx
>>> <disclaimer@xxxxxxxx> 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 disclaimer@xxxxxxxx
> <disclaimer@xxxxxxxx> 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.*
>