Hi Bryan, Appraisal is just a note, so it should be in the “note” table. The JSON for each note is stored in the notes field. You’ll need to use the MySQL JSON functions to extract the information you want https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html .
I hope this helps. Brian -- Brian Harrington (he/him) Data Migration Specialist LYRASIS brian.harring...@lyrasis.org From: <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Bryan W Sutherland <bsutherl...@mitre.org> Reply-To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Date: Thursday, November 19, 2020 at 1:50 PM To: "archivesspace_users_group@lyralists.lyrasis.org" <archivesspace_users_group@lyralists.lyrasis.org> Subject: [Archivesspace_Users_Group] Appraisal information database location Hello, I’m trying to locate where in the ASpace database the information within the item-level appraisal tag is located. There is date information within this tag that I would like to extract. My colleagues in technical support and I have been unable to find it and there doesn’t seems to be a report with that information either. Any help would be greatly appreciated, thanks! Bryan Sutherland Collections Management Archivist The MITRE Corporation Bedford, MA 781-271-8941
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group