Item change logs

47 views
Skip to first unread message

Mengu Yazicioglu

unread,
Aug 18, 2022, 5:03:18 PM8/18/22
to dspace-c...@googlegroups.com
Hi all,

I'm looking for a SQL script to find all the changes done to specific item, especially to find the changes in the embargo situation.
Does anyone have such an idea?

Thanks in advance.

Fatih Güneş

unread,
Aug 19, 2022, 3:40:06 AM8/19/22
to DSpace Community
Hi Mengu,
What is your Dspace version?

Mengu Yazicioglu

unread,
Aug 19, 2022, 9:33:55 AM8/19/22
to Fatih Güneş, DSpace Community
We are on 6.4

Thanks

Fatih Güneş <fa...@selensoft.com.tr>, 19 Ağu 2022 Cum, 10:40 tarihinde şunu yazdı:
--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/66e684f1-beb6-485b-88cf-67710eac782cn%40googlegroups.com.

Tim Donohue

unread,
Aug 29, 2022, 10:53:44 AM8/29/22
to DSpace Community
Hi,

DSpace does not currently track all changes made to Items.  It only tracks some major change (creation, withdraw, deletion) in the Item's "dc.description.provenance" fields. So, there's no way to query for historical change log information from the database.  The best option would be to look at your DSpace log files (if it was a relatively recent change or if you have historical log files) for the Item UUID, as you can find information in the logs on when that Item was accessed, updated, etc (and by which user).

Tim

Mengu Yazicioglu

unread,
Sep 3, 2022, 2:26:05 AM9/3/22
to Tim Donohue, DSpace Community
Thanks a lot for this information Tim

'Tim Donohue' via DSpace Community <dspace-c...@googlegroups.com>, 29 Ağu 2022 Pzt, 17:53 tarihinde şunu yazdı:
Reply all
Reply to author
Forward
0 new messages