I would look in the database table "item". It has a field called "item"."in_archive". Typically when an item gets deleted it sets item.in_archive to FALSE
So from the DB, you could look for all of the "deleted" items. So use your favorite SQL query tool (perhaps pgAdmin3 if your DB is postgres) SELECT * FROM item where item.in_archive = false; Or get all the metadata for the deleted items. SELECT item.item_id, item.in_archive, metadatafieldregistry.element, metadatafieldregistry.qualifier, metadatavalue.text_value, item.last_modified FROM public.item, public.metadatavalue, public.metadatafieldregistry WHERE item.item_id = metadatavalue.item_id AND metadatavalue.metadata_field_id = metadatafieldregistry.metadata_field_id AND item.in_archive = FALSE ORDER BY last_modified DESC; However, I think deletions to communities and collections make them go away, the items may remain behind as an artifact. Peter Dietz Systems Developer/Engineer Ohio State University Libraries On Fri, May 28, 2010 at 2:35 PM, Sands Alden Fish <sa...@mit.edu> wrote: > Others should provide some clarification on this, but typically deletions > are not "hard deletes" but soft, in that there is a deletion flag that a > cleanup process operates on occasionally. Perhaps the database still > contains the items, and you can revert the deletion by modifying the correct > tables? > > Sorry that this isn't more detailed. I've never had to dig around in that > logic before. > > -- > sands fish > Software Engineer > MIT Libraries > Technology Research & Development > sa...@mit.edu > E25-131 > > > > > On May 28, 2010, at 2:30 PM, Jeffrey W. Pearson wrote: > > Quick question: > > We had a user delete things he should not have. We have been able to > restore the filesystem stuff from backups. Unfortunately, the database > backups have been lost. All we really need is the content files. Is > there a way to rebuild the content files from just using what is on the > file system? > > Any help would be GREATLY appreciated, especially by the user who > deleted the data.... > > > > Jeff Pearson > USC Libraries > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Dspace-devel mailing list > Dspace-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-devel > > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > Dspace-devel mailing list > Dspace-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-devel > >
------------------------------------------------------------------------------
_______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel
