[Archivesspace_Users_Group] Appraisal information database location

Brian Harrington brian.harrington at lyrasis.org
Thu Nov 19 14:46:10 EST 2020

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 Harrington (he/him)
Data Migration Specialist
brian.harrington at lyrasis.org

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Bryan W Sutherland <bsutherland at mitre.org>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Thursday, November 19, 2020 at 1:50 PM
To: "archivesspace_users_group at lyralists.lyrasis.org" <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Appraisal information database location


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20201119/fbfe84ae/attachment.html>

More information about the Archivesspace_Users_Group mailing list