[Archivesspace_Users_Group] Database query to recreate inventory hierarchy?

[Olivia S Solis]

Hi Dave,
Thank you for the suggestion, which somehow had not occurred to me. I will
do some experimenting with it this afternoon! I've identified 470 different
resource records we have that potentially have this problem, so I'm
absolutely looking for the most efficient way to fix this.
Thanks!
Olivia

On Fri, Sep 20, 2019 at 9:21 AM Mayo, Dave <dave_mayo at harvard.edu> wrote:

> 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
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>


-- 
Olivia Solis, MSIS
Metadata Coordinator
Dolph Briscoe Center for American History
The University of Texas at Austin
2300 Red River St. Stop D1100
Austin TX, 78712-1426
(512) 232-8013
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20190920/ac33a610/attachment.html>