Claudia: EXCELLENT!! The SQL commands are exactly what I needed. Thank you!
At 03:43 AM 10/7/2008, Claudia Jürgen wrote: >Hi George, > >there is an old patch for the jspui >http://sourceforge.net/tracker/index.php?func=detail&aid=1615148&group_id=19984&atid=319984 >to assume another user. > >You might also simply look in the db: > >select * from item where submitter_id=IDofYourUser, >This will give you all items the user submitted. > >select w.* from workspaceitem w, item i where >i.submitter_id=IDofYourUser and i.item_id=w.item_id; >This will give you all the unfinished submission of a user > >select w.* from workflowitem w, item i where i.submitter_id=IDofYourUser > and i.item_id=w.item_id; >This will give you all the submissions of a user still in the workflow. >Workflows might also be viewed via the dspace-admin UI. > >To see, whether the user deleted an unfinished submission you got to >look at the logs. > >Hope that helps > >Claudia > > > >George Kozak schrieb: > > Claudia: > > > > Thank you...I should have stated that I am using 1.4.2 currently. DO > > you know of a way in that release? > > > > At 05:04 PM 10/6/2008, Claudia Juergen wrote: > >> Hi George, > >> > >> if you're using 1.5.x with xmlui there is a config option: > >> xmlui.user.assumelogin > >> If set to true the DSpace admin can login as another user. > >> > >> Hope that helps > >> > >> Claudia > >> > >> > >>> Hi... > >>> > >>> Is there a way for me (as Sys Admin) to see someone's "My DSpace" > >>> queue to guarantee that they have or have not submitted a request? I > >>> have a user who insists that he made a submission, but I do not find > >>> it archived nor is it in the workflow. > >>> > >>> *************************** > >>> George Kozak > >>> Coordinator > >>> Web Development and Management > >>> Digital Media Group > >>> 501 Olin Library > >>> Cornell University > >>> 607-255-8924 > >>> *************************** > >>> [EMAIL PROTECTED] > >>> > >>> > >>> ------------------------------------------------------------------------- > >>> This SF.Net email is sponsored by the Moblin Your Move Developer's > >>> challenge > >>> Build the coolest Linux based applications with Moblin SDK & win great > >>> prizes > >>> Grand prize is a trip for two to an Open Source event anywhere in the > >>> world > >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ > >>> _______________________________________________ > >>> DSpace-tech mailing list > >>> DSpace-tech@lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech > >>> > > > > *************************** > > George Kozak > > Coordinator > > Web Development and Management > > Digital Media Group > > 501 Olin Library > > Cornell University > > 607-255-8924 > > *************************** > > [EMAIL PROTECTED] > > > > > > ------------------------------------------------------------------------- > > This SF.Net email is sponsored by the Moblin > Your Move Developer's challenge > > Build the coolest Linux based applications > with Moblin SDK & win great prizes > > Grand prize is a trip for two to an Open Source event anywhere in the world > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > _______________________________________________ > > DSpace-tech mailing list > > DSpace-tech@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/dspace-tech > >------------------------------------------------------------------------- >This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >Build the coolest Linux based applications with Moblin SDK & win great prizes >Grand prize is a trip for two to an Open Source event anywhere in the world >http://moblin-contest.org/redirect.php?banner_id=100&url=/ >_______________________________________________ >DSpace-tech mailing list >DSpace-tech@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/dspace-tech *************************** George Kozak Coordinator Web Development and Management Digital Media Group 501 Olin Library Cornell University 607-255-8924 *************************** [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
