[Dspace-tech] Returning a taken task back to Pool?

2013-05-27 Thread Michael White
Hi, We have some items in Workflow that a member of staff has taken and so they are in their Owned tasks, but this member of staff is now on holiday and so we would like to recover these items and return them to the Workflow pool so that they can be picked up by another member of staff during

Re: [Dspace-tech] Returning a taken task back to Pool?

2013-05-27 Thread helix84
Hi Michael, before we dig into SQL, does this help? http://dspace.2283337.n4.nabble.com/Authorizations-and-Workflow-Steps-tp4656873p4656898.html Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Returning a taken task back to Pool?

2013-05-27 Thread Michael White
-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Returning a taken task back to Pool? Hi Michael, before we dig into SQL, does this help? http://dspace.2283337.n4.nabble.com/Authorizations-and-Workflow-Steps-tp4656873p4656898.html Regards, ~~helix84 Compulsory reading: DSpace Mailing List

Re: [Dspace-tech] Returning a taken task back to Pool?

2013-05-27 Thread helix84
Workflow is an area I have almost no experience with. But if you want to look around in the database, look at the *workflowitem* and *workspaceitem*tables. You'll be interested in the *item_id* and *owner* columns. To look up *item_id* by title, you can do SELECT item_id, textvalue FROM

Re: [Dspace-tech] Returning a taken task back to Pool?

2013-05-27 Thread Joseph Greene
. Re: Change permissions in batch (helix84) -- Message: 1 Date: Mon, 27 May 2013 14:14:39 +0200 From: helix84 heli...@centrum.sk Subject: Re: [Dspace-tech] Returning a taken task back to Pool? To: Michael White michael.wh