<div dir="ltr">Thank you! The relationship info helps for sure. In the fog of my memory, I remember making table joins, and I image this info would help.<div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><br></div><div><span><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:14.6667px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"></span></p><span><span style="font-size:14.6667px;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap;background-color:transparent"><hr></span></span><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:14.6667px;font-weight:bold;vertical-align:baseline;white-space:pre-wrap"><font face="arial, helvetica, sans-serif" color="#444444">Margaret Turman Kidd</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:14.6667px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><font color="#444444">Access and Electronic Records Archivist, Special Collections & Archives</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:14.6667px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><font color="#444444">VCU Libraries | Health Sciences Library</font></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:14.6667px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><font color="#444444">Virginia Commonwealth University</font></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><font color="#444444">509 N. 12th Street / Box 980582, Richmond, VA 23298-0582</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><font color="#444444">(804) 828-3152</font></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><font color="#444444"><a href="mailto:kiddm@vcu.edu" target="_blank">kiddm@vcu.edu</a></font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13.3333px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"><span style="font-family:Arial,Helvetica,sans-serif;font-size:small;white-space:normal"><font color="#444444">Pronouns: she/her<br></font></span><font color="#8d8d8d"><br></font></span></p><span style="text-decoration:underline;font-size:13.3333px;font-family:Arial;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"></span></span></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 20, 2023 at 3:44 PM Valerie Addonizio <<a href="mailto:vaddonizio@atlas-sys.com">vaddonizio@atlas-sys.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-4565318927507531769">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_-4565318927507531769WordSection1">
<p class="MsoNormal">Margaret,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">There is this classic resource that I’ve leaned on in the past:
<a href="https://campuspress.yale.edu/yalearchivesspace/2015/09/08/mucking-around-in-archivesspace-locally/comment-page-1/" target="_blank">
https://campuspress.yale.edu/yalearchivesspace/2015/09/08/mucking-around-in-archivesspace-locally/comment-page-1/</a><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I was recently made aware of this resource on the tech-docs page; though it was written against 2.7.1, a lot of the basics are the same:
<a href="https://github.com/archivesspace/tech-docs/blob/master/architecture/backend/database.md" target="_blank">
https://github.com/archivesspace/tech-docs/blob/master/architecture/backend/database.md</a> Though they are complex, you may find the sample queries (halfway down the page) helpful to get you started. You’ll also want to scan the relationship tables since you’re
likely interested in locations and their relationships to top containers (or vice versa).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Neither of those is truly quickstart, but they are the two ASpace-specific resources I know of.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">-V<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Margaret Kidd<br>
<b>Sent:</b> Tuesday, June 20, 2023 3:13 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Querying ArchivesSpace using MySQL Workbench<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hello all,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I recently gained access to a read-only copy of our production database using MySQL Workbench. My hope is that I could use it to query our data to create the kinds of reports we need. For example, I would like a better shelf list report
as the current option in ASpace doesn't suit our needs. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">The problem is that my skills in this area are hopelessly out-of-date. The last time I worked with MySQL was 20 years ago in my pre-archives life (ugh, it hurts to write that sentence and realize how old I'm getting). Does anyone have any
tips or could point me to a basic tutorial that may help? The stuff I've found so far isn't very helpful for me. I just need to learn some quick and dirty basics to get at this information quickly. Hopefully, I can spend some time later on tutorials to get
more comfortable.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Any suggestions would be most appreciated.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Margaret<br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-family:Arial,sans-serif;color:black">
<hr size="2" width="100%" align="center">
</span></div>
<p style="margin:0in"><b><span style="font-family:Arial,sans-serif;color:rgb(68,68,68)">Margaret Turman Kidd</span></b><u></u><u></u></p>
<p style="margin:0in"><span style="font-family:Arial,sans-serif;color:rgb(68,68,68)">Access and Electronic Records Archivist, Special Collections & Archives</span><u></u><u></u></p>
<p style="margin:0in"><span style="font-family:Arial,sans-serif;color:rgb(68,68,68)">VCU Libraries | Health Sciences Library</span><u></u><u></u></p>
<p style="margin:0in"><span style="font-family:Arial,sans-serif;color:rgb(68,68,68)">Virginia Commonwealth University</span><u></u><u></u></p>
<p style="margin:0in"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(68,68,68)">509 N. 12th Street / Box 980582, Richmond, VA 23298-0582</span><u></u><u></u></p>
<p style="margin:0in"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(68,68,68)">(804) 828-3152</span><u></u><u></u></p>
<p style="margin:0in"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(68,68,68)"><a href="mailto:kiddm@vcu.edu" target="_blank">kiddm@vcu.edu</a></span><u></u><u></u></p>
<p style="margin-right:0in;margin-bottom:12pt;margin-left:0in">
<span style="font-size:12pt;font-family:Arial,sans-serif;color:rgb(68,68,68)">Pronouns: she/her</span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div></blockquote></div>