[Archivesspace_Users_Group] Database query to recreate inventory hierarchy?

[Mayo, Dave]

This is limited to _published_ AOs, so if you want to get all of them, you’d probably need to use something like https://archivesspace.github.io/archivesspace/api/#get-a-resource-tree and then walk down the tree and get uris/ids manually.

--
Dave Mayo (he/him)
Senior Digital Library Software Engineer
Harvard University > HUIT > LTS

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of "Mayo, Dave" <dave_mayo at harvard.edu>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Friday, September 20, 2019 at 10:13 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database query to recreate inventory hierarchy?

No joy then, I’m sorry to say.  Honestly, since the API is going to be in the mix to use eventually, I’d suggest looking at this endpoint:

https://archivesspace.github.io/archivesspace/api/#get-the-list-of-uris-of-this-published-resource-and-all-published-archival-objects-contained-within-ordered-by-tree-order-i-e-if-you-fully-expanded-the-record-tree-and-read-from-top-to-bottom<https://urldefense.proofpoint.com/v2/url?u=https-3A__archivesspace.github.io_archivesspace_api_-23get-2Dthe-2Dlist-2Dof-2Duris-2Dof-2Dthis-2Dpublished-2Dresource-2Dand-2Dall-2Dpublished-2Darchival-2Dobjects-2Dcontained-2Dwithin-2Dordered-2Dby-2Dtree-2Dorder-2Di-2De-2Dif-2Dyou-2Dfully-2Dexpanded-2Dthe-2Drecord-2Dtree-2Dand-2Dread-2Dfrom-2Dtop-2Dto-2Dbottom&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=_Mv1dY22K7jvT5MD7xjbvGVzRDOUMhx4WYcnPSIzYnE&m=2fMESNfVzsOLpA4jhFdQmTe1ChlVGDyaYYraUA2CpB0&s=RXCUneIYE1hDsWDlAZ08krr_Xa8JXXiagrBveWRqSDc&e=>

The API is probably the easiest way to get this information, though if you’re fetching this info for _all_ records it’s definitely gonna be slower.

--
Dave Mayo (he/him)
Senior Digital Library Software Engineer
Harvard University > HUIT > LTS

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Olivia S Solis <livsolis at utexas.edu>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Friday, September 20, 2019 at 10:05 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database query to recreate inventory hierarchy?

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