Forums / Setup & design / Clear collaboration group list
Antoine Schmid
Thursday 16 March 2006 5:35:23 am
Hi,
After a validation process (workflow) my objects are stored in the collaboration group list in collaboration/group/list/[number].
My question is: how can I remove elements from this interface ? I didn't figure out how it works (if it's possible) but this is espacially important during the tests and before the final publishing.
Perhaps I need to clear them manually from the database or there exists a script that runs with the cronjobs.
I would appreciate your experience
Antoine
Tuesday 21 March 2006 11:28:39 pm
No one ?
Elena Ivanova
Tuesday 21 December 2010 12:47:22 am
Hello,
I know this is an old topic, but it has not been answered. I created a workflow for approving content before published. After that I needed to delete some of the already approved and published objects, but thay are still listed in Collaboration - Item list.
Could someone help - how to clear this list?
Thanks.
Tuesday 21 December 2010 1:09:38 am
I found the following topic http://share.ez.no/forums/setup-design/clear_approve_history/%28from%29/ez.no/ that deals with something similar.
Firstly I tried with:
php update/common/scripts/cleanup.php workflow
but nothing happened. Then I tried with
php update/common/scripts/cleanup.php collaboration
but the script cleared the whole list. Is there any way to clear only those items that correspond to deleted objects.
Wednesday 22 December 2010 12:36:31 am
any idea, advice?
Nicolas Pastorino
Wednesday 22 December 2010 5:14:21 am
Hi Elena,
Indeed, using the cleanup.php script with the collaboration option will simply truncate the associated tables. The executed code is eventually this one :
$db = eZDB::instance(); $db->begin(); $db->query( "DELETE FROM ezcollab_item" ); $db->query( "DELETE FROM ezcollab_item_group_link" ); $db->query( "DELETE FROM ezcollab_item_message_link" ); $db->query( "DELETE FROM ezcollab_item_participant_link" ); $db->query( "DELETE FROM ezcollab_item_status" ); $db->query( "DELETE FROM ezcollab_notification_rule" ); $db->query( "DELETE FROM ezcollab_profile" ); $db->query( "DELETE FROM ezcollab_simple_message" ); $db->commit();
and i could not find any related option to only clean-up archived items. But what are you exactly trying to achieve, at a functional level ?
Let us know,Cheers,
-- Nicolas Pastorino Director Community - eZ Member of the Community Project Board eZ Publish Community on twitter: http://twitter.com/ezcommunity t : http://twitter.com/jeanvoye G+ : http://plus.tl/jeanvoye
Wednesday 22 December 2010 5:49:00 am
Hi Nicolas,
Thanks for your feedback. I'm working on the following - I would like to have my users approved by administrator, before getting created. To achieve that, I set 2 workflows, the first one with event/approve, the second one with event/Multiplexer with classes to run 'User'.
My site is currently in development, so I didn't set cronjobs, but perform this manualy. All this works, as I expected. My issue came when I decided to delete the fake users that had been used for testing only. I deleted them, but they still appear in Item list, under Collaboration section. Do you know if there is a way to remove only deleted users from there.
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs