Good afternoon,
In addition to the submitter's id in the item table, their name is recorded in
the metadatavalue table in the provenance field (metadata_field_id = 28.) I'm
not sure when this information is created in the database, but it's probably
there if there's a record in the workspaceitem table. I'm also not sure if it
shows up anywhere else.
It would probably be better if you can cancel the first submission and
re-submit it under the new eperson's account.
B--
From: Calloni, Rodrigo [mailto:[email protected]]
Sent: Thursday, March 07, 2013 2:01 PM
To: Andrea Schweer; [email protected]
Subject: Re: [Dspace-tech] In which Oracle table I can find workspaceID?
Hello Andrea
I ran the following SQL and it brought 0 results:
select * from workspaceitem where workspace_item_id = 89654;
Any ideas?
Rodrigo
From: Andrea Schweer [mailto:[email protected]]
Sent: Thursday, March 07, 2013 3:35 PM
To: [email protected]<mailto:[email protected]>
Cc: Calloni, Rodrigo
Subject: Re: [Dspace-tech] In which Oracle table I can find workspaceID?
Hi Rodrigo,
On 08/03/13 07:51, Calloni, Rodrigo wrote:
When I go to the list of "Unfinished Submissions" I see the following link
syntax for those items:
http://hostname/submit?workspaceID=89654
I want to see how this unfinished submission is recorded in the database. Which
Oracle table should I look for it?
Basically I want to see if it is possible to update the Database in order to
move an unfinished submission to another eperson.
It refers to the workspace_item_id column in the workspaceitem table. You
should be able to move the submission to the new eperson by following the link
(via item_id) to the item table, which has a submitter column that's a foreign
key to the eperson id.
I just noticed that there's also a table called epersongroup2workspaceitem but
I don't know what it does.
As usual when hacking the database directly, make a backup of your database
before you try it and do it on a non-production environment first. If you're
successful, let us know what you did.
cheers,
Andrea
--
Dr Andrea Schweer
IRR Technical Specialist, ITS Information Systems
The University of Waikato, Hamilton, New Zealand
------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
