<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Here is an example (not my own):</p>
<p><br>
</p>
<p><a class="moz-txt-link-freetext" href="https://github.com/harvard-library/harvard_aspace_reports/blob/b96981a13debd62be88a4d11ccd39d692eaed857/backend/model/resource_top_containers.rb#L4-L12">https://github.com/harvard-library/harvard_aspace_reports/blob/b96981a13debd62be88a4d11ccd39d692eaed857/backend/model/resource_top_containers.rb#L4-L12</a></p>
<p><br>
</p>
<p>Andrew.</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 21/03/2022 03:52, Neal Fitzgerald
wrote:<br>
</div>
<blockquote type="cite" cite="mid:ME2PR01MB3619FF6113741EBEE9368D4FDD169@ME2PR01MB3619.ausprd01.prod.outlook.com">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
Hi All</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
I am trying to create a report that uses the resource.id as a
parameter to output a list of associated archival_objects and
specific metadata from various related tables for a metadata
transfer to another library system. The new 3.2.0 custom report
feature does not fit our purposes.<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<span style="font-size:12pt">The instructions at <a href="https://archivesspace.github.io/tech-docs/customization/reports.html" moz-do-not-send="true" class="moz-txt-link-freetext">https://archivesspace.github.io/tech-docs/customization/reports.html</a>
are unhelpfully brief. viz:"Implement your own initializer if
your report has any parameters." But no details about how to
do that exactly.
<br>
</span>
<div style="font-size:12pt"><br>
</div>
<div style="font-size:12pt">I have created the custom reports we
have so far starting from existing report with similar tables
and so on and changing the SQL query. There are no existing
reports that have parameters other than dates, so nothing to
copy and paste and tinker with for a new initializer. My
attempts to create my own initializer have not succeeded.
Anything I tried crashed the whole reports selection page,
with very cryptic messages in the logs.<br>
</div>
<div style="font-size:12pt"><br>
</div>
<div style="font-size:12pt">Has anyone created an initializer
that allows a selection by resource number, ie an integer
value or range of integer values?</div>
<div style="font-size:12pt"><br>
</div>
<div style="font-size:12pt">Any help would be greatly
appreciated.</div>
<div style="font-size:12pt"><br>
</div>
<div style="font-size:12pt">Cheers</div>
<div style="font-size:12pt"><br>
</div>
<div style="font-size:12pt">Neal Fitzgerald<br>
</div>
<span style="font-size:12pt"></span> <br>
</div>
<p> </p>
<div style="font-size:11pt;font-family:Century Gothic">
<p><b>Neal Fitzgerald | Senior Specialist, Library Systems &
Digital Preservation | Collection Development &
Description
</b><br>
State Library Victoria | 328 Swanston Street | Melbourne VIC
3000<br>
T +61 3 8664 7103 | <a class="moz-txt-link-abbreviated" href="mailto:nfitzgerald@slv.vic.gov.au">nfitzgerald@slv.vic.gov.au</a><br>
<a href="http://slv.vic.gov.au" tabindex="0" moz-do-not-send="true">slv.vic.gov.au</a></p>
<p><br>
<img alt="slv" src="http://www.slv.vic.gov.au/sites/default/files/email_signature/AOC_esignature.png" moz-do-not-send="true"></p>
<table>
<tbody>
<tr>
<td colspan="3"><a href="https://www.slv.vic.gov.au/email_campaign" tabindex="0" moz-do-not-send="true"><img src="https://www.slv.vic.gov.au/sites/default/files/email_signature/signature.jpg?9" moz-do-not-send="true"></a></td>
<td> </td>
</tr>
</tbody>
</table>
</div>
<p> </p>
This message and any attachment is intended only for the use of
the Addressee and may contain information that is PRIVILEGED and
CONFIDENTIAL. If you are not the intended recipient, you are
hereby notified that any dissemination of this communication is
strictly prohibited. If you have received this communication in
error, please delete all copies of the message and its attachments
and notify the sender immediately. Thank you.
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
</body>
</html>