Forums / Setup & design / Clear collaboration group list

Clear collaboration group list

Author Message

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

Antoine Schmid

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.

Elena Ivanova

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.

Thanks.

Elena Ivanova

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

Elena Ivanova

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.

Thanks.