[Archivesspace_Users_Group] Creating a report with selection parameters other than dates

[Andrew Morrison]

Here is an example (not my own):


https://github.com/harvard-library/harvard_aspace_reports/blob/b96981a13debd62be88a4d11ccd39d692eaed857/backend/model/resource_top_containers.rb#L4-L12


Andrew.




On 21/03/2022 03:52, Neal Fitzgerald wrote:
> Hi All
>
> 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.
>
> The instructions at 
> https://archivesspace.github.io/tech-docs/customization/reports.html 
> are unhelpfully brief. viz:"Implement your own initializer if your 
> report has any parameters." But no details about how to do that exactly.
>
> 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.
>
> Has anyone created an initializer that allows a selection by resource 
> number, ie an integer value or range of integer values?
>
> Any help would be greatly appreciated.
>
> Cheers
>
> Neal Fitzgerald
>
> *Neal Fitzgerald | Senior Specialist, Library Systems & Digital 
> Preservation | Collection Development & Description *
> State Library Victoria | 328 Swanston Street | Melbourne VIC 3000
> T +61 3 8664 7103 | nfitzgerald at slv.vic.gov.au
> slv.vic.gov.au <http://slv.vic.gov.au>
>
>
> slv
>
> <https://www.slv.vic.gov.au/email_campaign> 	
>
> 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.
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220321/dff5b322/attachment.html>