dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

This should be obvious, but better to remind people one time too much:
If you decide to run DELETE queries, please always remember to first do a
backup (pg_dump).

On Nov 18, 2016 8:27 AM, "channara rin" <rin.channara@xxxxxxxxx> wrote:

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