dhis2-users team mailing list archive

[Ant Snyman <ant@xxxxxxxx>]

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.*