dhis2-users team mailing list archive

[nsanzumuhire venuste <vensanze@xxxxxxxx>]

Thank you Jim GRACE this worked fine.


Le Lundi 11 août 2014 19h35, Jim Grace <jimgrace@xxxxxxxxx> a écrit :
 


Dear Nsanzumuhire Venuste,

The message means that some data has already been approved at this level. If you can locate the data that was approved in the approval report, you can remove the approval record by clicking on "Unapprove". If all data that has been approved at this level is unapproved, then you should be able to remove the approval level.

If you want to remove *all* data approvals through the back end, you can do:

delete from dataapproval;

Then you can delete any approval level.

If you only want to delete the data approvals for one level, you can look through the approval levels with:

select * from dataapprovallevel;

Note that dataapprovallevelid value for the approval level you want to delete. Then delete the approvals for that level with:

delete from dataapproval where dataapprovallevelid = nnnn;

Then you can delete that approval level.

Cheers,
Jim Grace




On Mon, Aug 11, 2014 at 1:03 PM, nsanzumuhire venuste <vensanze@xxxxxxxx> wrote:

Dear all i have created the approval level in settings,and  have selected facilities as aproval level in settings and when i try to delete it cause i whant to change the level of approval,i get this message:
>Object not deleted because it is associated by objects of type DataApproval
but when i also try to create another one like Province i can delete it no problem.does it need to delete it in Back end?
>Did any one met  this issue?
>
>Regards.
>
>
>
>
>
>
>Le Jeudi 7 août 2014 10h05, "Wilson, Randy" <rwilson@xxxxxxx> a écrit :
> 
>
>
>Not sure if anyone else has seen this issue, but the list of datasets displayed when selecting reporting rates is not complete.  I've cleared cache and checked the completeness table for the period in question and all of the datasets are in the analytics table.  I wonder if the SQL statement used to fill the combo box has a "limit" statement.
>
>-- 
>
>Randy Wilson
>Senior HMIS and
Data Use Advisor, Ministry of Health/Rwanda
>Integrated
Health Systems Strengthening Project
>Management
Sciences for Health, Inc. (MSH)
>BP 371
>Kigali, Rwanda
>+250-788308835
>Skype Name
(wilsonrandy_us) 
>www.msh.org 
>Stronger health systems. Greater health impact.
> 
>This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.
>_______________________________________________
>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
>
>