<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">And Steve, now that I’m looking at your question, I *<b>think</b>* that everything already mentioned should point you in the right direction for doing that search with the API.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It sounds like your use case might be aimed at performing very granular updates, but in case it’s helpful, here’s the approach that Hudson Molonglo (thanks James, et al.!) provided for us so that we can figure out which finding aids to
export, adding a new endpoint named “/resource-update-feed” via a plugin. See <a href="https://github.com/hudmol/archivesspace_export_service/tree/master/backend">
https://github.com/hudmol/archivesspace_export_service/tree/master/backend</a> . In this case, we wanted to know not just when a resource or archival record had been edited in a finding aid, but when any of the records that link to it were (e.g. the archival
object wasn’t edited, but an associated digital object was). We use that endpoint as part of a larger service, but I’ve also found it useful in other contexts.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Additionally, it was important to figure out which records had been unpublished or suppressed since a particular time, which is why I like this approach, since the idea is that you send a request to that new endpoint, and it will return
to you a list of IDs that need to be added (either because they’re brand new or because they’ve been edited), as well as a list of IDs that should be removed. Again, this use case was just for Resource records, but I imagine that a similar approach would
be useful for other record types.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Mark<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Seth Shaw<br>
<b>Sent:</b> Friday, 08 November, 2019 11:26 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Help using AS Restful API to query<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Thanks, James and Mark. I appreciate the additional pointers. (And sorry for high-jacking your thread, Steve!)<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Fri, Nov 8, 2019 at 8:20 AM Custer, Mark <<a href="mailto:mark.custer@yale.edu">mark.custer@yale.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Seth,
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Here’s another example:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">search?type[]=archival_object&page=1&aq=<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white">
<span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">{</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"query"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">{</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"op"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"AND"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"subqueries"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">[</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">{</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"field"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"keyword"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"value"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"39002102378974"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"jsonmodel_type"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"field_query"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"negated"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#000066;background:white">false</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"literal"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#000066;background:white">false</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">}</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">{</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"field"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"types"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:yellow">"value"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:yellow">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:yellow">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:yellow">"pui"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:yellow">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"jsonmodel_type"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"field_query"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:yellow">"negated"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:yellow">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:yellow">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#000066;background:yellow">true</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">}</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">]</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"jsonmodel_type"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"boolean_query"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">}</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">,</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1E6496;background:white">"jsonmodel_type"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#640032;background:white">:</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white">
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;background:white">"advanced_query"</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black;background:white"><br>
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#960000;background:white">}</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">In that case, for example, we might have one archival object where that barcode has been applied. In the Solr index, there will be two documents, if and only if that record has
been published. But, we can exclude the PUI document in the result set with that second part of the subquery.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Mark<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b>From:</b>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [mailto:<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>Seth Shaw<br>
<b>Sent:</b> Friday, 08 November, 2019 11:13 AM<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> Re: [Archivesspace_Users_Group] Help using AS Restful API to query<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">That might be it. We don't use the PUI for patron access; but we do still have it left on as the staff occasionally look at it. Certainly something to investigate.<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Regardless, either the API should use
<i>one</i> index consistently, have a documented filter (I don't see one there) and/or give some other obvious indication as to where a result came from.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Fri, Nov 8, 2019 at 8:02 AM James Bullen <<a href="mailto:james@hudmol.com" target="_blank">james@hudmol.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi Seth,<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I’m not seeing that. Could it be you’re seeing pui docs as well - the instance I’m testing on has the pui turned off.<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">James<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><o:p> </o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Nov 8, 2019, at 10:51 AM, Seth Shaw <<a href="mailto:seth.shaw@unlv.edu" target="_blank">seth.shaw@unlv.edu</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">James, I was hoping using the filter as you described would remove the duplicate results issue I was having by using the advanced query compound search; but I'm seeing the same
thing as before. <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Running the search via the API: 'archivestest:8089/search?type[]=archival_object&page=1&filter={"query":{"comparator":"greater_than","field":"system_mtime","value":"2019-10-02","jsonmodel_type":"date_field_query"}}'
returns, in part, `{"page_size":10,"first_page":1,"last_page":874,"this_page":1,"offset_first":1,"offset_last":10,"total_hits":8732,` ...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Whereas the SQL query `SELECT count(*) FROM archival_object WHERE system_mtime > '2019-10-02';` is returning "4369" (half the results of the REST query).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Have you run into this issue before?<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Fri, Nov 8, 2019 at 7:34 AM James Bullen <<a href="mailto:james@hudmol.com" target="_blank">james@hudmol.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Something like this works for me:<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">/search type[]=resource type[]=archival_object page=1 filter={"query":{"comparator":"greater_than","field":"system_mtime","value":"2019-10-02","jsonmodel_type":"date_field_query"}}<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><o:p> </o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Nov 8, 2019, at 10:24 AM, Seth Shaw <<a href="mailto:seth.shaw@unlv.edu" target="_blank">seth.shaw@unlv.edu</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">To do this you need to use the advanced query parameter which, unfortunately, is not well documented. There are a few email threads that describe using the advanced search though:<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Fhtdig%2Farchivesspace_users_group%2F2015-June%2F001734.html&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973732409&sdata=4HOPKRSdqZZdb%2FZ15TJsDOQ%2B%2FxQrFf8Msy9nE77wGQc%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2015-June/001734.html</a><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I've formulated queries like you describe before (I'll have to dig through my notes to see if I can find it again); but the result set was consistently giving me back duplicate
results for some unknown reason; so I stopped using it. <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Ideally, we would be able to add a 'modified_since' parameter to each entity's endpoint to get the most recent set. The capability exists in the code, but hasn't been exposed to
the REST end-point. I've submitted a ticket that will hopefully lead to this being resolved: <a href="https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fbrowse%2FANW-962%3Ffilter%3D-2&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973742403&sdata=Mju0CwGm0Fqsvy5bi6G45brUiBOylJiZPYHgXoTNv1U%3D&reserved=0" target="_blank">https://archivesspace.atlassian.net/browse/ANW-962?filter=-2</a>.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Fri, Nov 8, 2019 at 7:07 AM Steve Mattison <<a href="mailto:smattiso@nd.edu" target="_blank">smattiso@nd.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Community,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I'm new to using ArchivesSpace, and new to using the AS API. I need to use the API to search within a given repository to find records that have been modified after a particular
time (e.g. modified within the last 48 hours). (We then want to export metadata related to those resources or archival_objects for a project we're working on.)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I have found the documentation for
<a href="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Farchivesspace.github.io%2Farchivesspace%2Fapi%2F%3Fshell%23search-this-repository&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973752395&sdata=7WZLNWnShXavBBsLzHPBDZzLutLClo%2BwNeevuUvd9eI%3D&reserved=0" target="_blank">
search-this-repository</a>, but don't know how to formulate a query to find all resources and/or archival_objects where the system_mtime is after a particular time. I would be fine with performing two searches, one for resources and one for archival_objects,
if that is required.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Any help with the syntax for the query would be much appreciated.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thanks for your help.<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">--
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Arial",sans-serif">Steve Mattison</span></b><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><i><span style="font-family:"Arial",sans-serif">Lead Software Engineer, Digital Library Technologies</span></i><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><i><span style="font-family:"Arial",sans-serif">Hesburgh Libraries</span></i><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Arial",sans-serif">University of Notre Dame</span></b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Arial",sans-serif">271 Hesburgh Library</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Arial",sans-serif">Notre Dame, IN 46556-5629</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Arial",sans-serif">o:</span></b><span style="font-family:"Arial",sans-serif"> 574-631-8559</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Arial",sans-serif">e: </span></b><a href="mailto:steve.mattison@nd.edu" target="_blank"><span style="font-family:"Arial",sans-serif;color:#1155CC">steve.mattison@nd.edu</span></a><o:p></o:p></p>
</div>
</div>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Arial",sans-serif"><img border="0" id="_x0000_i1025" src="https://docs.google.com/uc?export=download&id=1eLUXKKJMijoIFzQtpJutmM1uLHON9ZDt&revid=0B-gl36FdlSuTV2ZPM1NBek5HamNiOWN1UllhT3d2VWtCU3hjPQ" alt="https://docs.google.com/uc?export=download&id=1eLUXKKJMijoIFzQtpJutmM1uLHON9ZDt&revid=0B-gl36FdlSuTV2ZPM1NBek5HamNiOWN1UllhT3d2VWtCU3hjPQ"></span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<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="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973752395&sdata=fevX5AF8SWAFXqivwvqFMgz%2BliJVQuLyeQqyOBJDpe4%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<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="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973762387&sdata=wiG8sxfVwA8MbIriUUkPeTD4NSOEzCM8uQYyZoV8Ml0%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
<br>
<br>
!DSPAM:5dc588a9250937848916637!<o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<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="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973762387&sdata=wiG8sxfVwA8MbIriUUkPeTD4NSOEzCM8uQYyZoV8Ml0%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">!DSPAM:5dc58f16257571993821028! _______________________________________________<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="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973772382&sdata=Edp5U64nNxhEKyrvFCUAsKiiRlAPenwlM2dc6QJr6FM%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
<br>
<br>
!DSPAM:5dc58f16257571993821028!<o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<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="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973772382&sdata=Edp5U64nNxhEKyrvFCUAsKiiRlAPenwlM2dc6QJr6FM%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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="https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7C14a98c82e2d841b696f508d764686ccb%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C1%7C637088271973782388&sdata=BEN4USjdkzt3LSt3fhp3jvCS2DfYstVnYZWv6r4Hdpg%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</body>
</html>