|
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
|
|
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.
|
|
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.
|
