topic Re: How to clear events in 'Site Activities' dashlet? in Alfresco Archive

How to clear events in 'Site Activities' dashlet?

dc41 — Thu, 26 Mar 2009 22:37:36 GMT

How does one clear the "site activities" history that's displayed in the dashlet?

Re: How to clear events in 'Site Activities' dashlet?

janv — Fri, 27 Mar 2009 09:10:38 GMT

By default, activity feed entries are cleaned when they're more than a month old. This can be configured (up or down) by overriding the "feedCleaner" bean.

http://wiki.alfresco.com/wiki/Install_Activity_Service#Custom_Bean_Configuration

If you wish to forcefully clear all feed entries for a specific site, then you would need to delete them directly from the DB, for example:


delete from alf_activity_feed where site_network = 'mysite' and (feed_user_id = '' or feed_user_id is null);
‍‍‍

If you do decide to access the DB directly, then please take a backup first.

Thanks,
Jan

Re: How to clear events in 'Site Activities' dashlet?

dc41 — Fri, 27 Mar 2009 17:47:00 GMT

Thanks!

Re: How to clear events in 'Site Activities' dashlet?

alexandref — Wed, 19 Dec 2012 17:44:16 GMT

I want to clear events in "Site Activities" dashlet but i don't know how to access at my database

My alfresco works with postgreql

Re: How to clear events in 'Site Activities' dashlet?

jpfi — Thu, 20 Dec 2012 08:56:31 GMT

well, then it's time to learn how to access a relational database like postgresql 🙂
cheers, jan

Re: How to clear events in 'Site Activities' dashlet?

vrugginkj — Wed, 12 Jun 2013 06:29:30 GMT

Jan is right. I'm also new with postgresql, but if you google on psql (commande line for postgresql) and you can access your host, you should be able to find it

Jaco.

Re: How to clear events in 'Site Activities' dashlet?

maggiehellstrom — Thu, 30 Oct 2014 14:01:02 GMT

Hi all,
how does this work for newer versions of Alfresco? I have Alfresco Community 5.0, and would like to do the same things here - i.e. both use the "bean method" to change default values, as well as applying SQL commands to the database directly…
Cheers,
Maggie