On Mon, Feb 18, 2013 at 4:31 AM, Hugh Paterson III
<[email protected]> wrote:
> Also is there a modification, or a hack which will automatically add to the 
> provenance record of an item who made changes (and what the changes were), 
> changes like the adding of a digital object to the bit stream or changed a 
> metadata element's value?

This might be the way to go, but it won't help you with the records
modified until this date.

What you could do now is look at the last modified date of files in
the assetstore and associate them with items using SQL. You can look
up the filename in the "internal_id" column of the "bitstream" table
to find "bitstream_id", then look up the bundle and item which it
belongs to using "bundle2bitstream" and "item2bundle". If handle is
preferable to "item_id", you can look that up in the "handle" column
of the "handle" table (where resource_id = item_id).

If you need to find the item's various dates, they're in the
"metadatavalue" table, where you can look it up by "item_id" and
filter by "metadata_field_id" (the names of fields can be translated
to/from readable DC by looking them up in "metadataschemaregistry" and
"metadatafieldregistry").

Let us know if you have a problem getting it to work.


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
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

Reply via email to