DHIS2 chart or table deletion

Support - Assistance technique
1

Hi all,

In my DHIS2 database some of the charts and pivot tables were created by various superusers at the time of database development. Although now all of those superusers are no longer available in database but still being a superuser I can’t delete any item created by any other user. Therefore is there a way to delete all those items (charts, graphs) created by other superusers?

Thanks,

Raheel

2

Dear Raheel,

You need to use an SQL command to delete these charts and tables based on their IDs.

Regards

···

On Tue, Jun 30, 2015 at 10:56 PM, Raheel Ayaz raheelayaz@gmail.com wrote:

Hi all,

In my DHIS2 database some of the charts and pivot tables were created by various superusers at the time of database development. Although now all of those superusers are no longer available in database but still being a superuser I can’t delete any item created by any other user. Therefore is there a way to delete all those items (charts, graphs) created by other superusers?

Thanks,

Raheel

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139

ptb3000@gmail.com | prosper@dhis2.org | Skype: prospertb

3

Thanks Knut. I have been able to delete extra charts and tables by using their login ids.

Best,

Raheel

···

On Fri, Jul 3, 2015 at 7:56 AM, Prosper BT ptb3000@gmail.com wrote:

Dear Raheel,

You need to use an SQL command to delete these charts and tables based on their IDs.

Regards

On Tue, Jun 30, 2015 at 10:56 PM, Raheel Ayaz raheelayaz@gmail.com wrote:

Hi all,

In my DHIS2 database some of the charts and pivot tables were created by various superusers at the time of database development. Although now all of those superusers are no longer available in database but still being a superuser I can’t delete any item created by any other user. Therefore is there a way to delete all those items (charts, graphs) created by other superusers?

Thanks,

Raheel

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139

ptb3000@gmail.com | prosper@dhis2.org | Skype: prospertb

–