How to clear events in 'Site Activities' dashlet?

[dc41]

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

[janv]

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

[dc41]

Thanks!

[alexandref]

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

[vrugginkj]

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.

[jpfi]

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

[maggiehellstrom]

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