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 On Friday, August 19, 2022 at 8:33:55 AM UTC-5 mengu.ya...@gmail.com wrote: > We are on 6.4 > > Thanks > > Fatih Güneş <fa...@selensoft.com.tr>, 19 Ağu 2022 Cum, 10:40 tarihinde > şunu yazdı: > >> Hi Mengu, >> What is your Dspace version? >> >> On Friday, 19 August 2022 at 00:03:18 UTC+3 mengu.ya...@gmail.com wrote: >> >>> 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. >>> >>> -- >> 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 >> >> <https://groups.google.com/d/msgid/dspace-community/66e684f1-beb6-485b-88cf-67710eac782cn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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-community+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/722bbbee-3a58-4cee-bbbf-9b1b4456d172n%40googlegroups.com.
