[Archivesspace_Users_Group] Appraisal information database location

[Brian Harrington]

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.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

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

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