Re: [Archivesspace_Users_Group] Unprocessed Accessions Report

2020-10-02 Thread Linda Hocking
Thank you all for your suggestions! We think we may be able to use one of Noah's reports, just have to get our consultant to install it. We do not have API access so that seems like the better option. Thanks again! Linda From: archivesspace_users_group-boun...@lyralists.lyrasis.org On Behalf

Re: [Archivesspace_Users_Group] Custom reports with string params?

2020-10-02 Thread Mayo, Dave
Hi, We have a plugin we wrote with some custom SQL reports – this one uses a string parameter for an EADID or list of EADIDs - https://github.com/harvard-library/harvard_aspace_reports/blob/master/backend/model/resource_top_containers.rb This is currently installed in production and working;

Re: [Archivesspace_Users_Group] Custom reports with string params?

2020-10-02 Thread Karen Miller
Hi Nick, I have an SQL query that I've embedded into an Excel spreadsheet (as a .odc file) which prompts the user for a value. The value I'm prompting for is numeric, but the code could be adjusted to take a string. I don't think this is what you want, but if it is, please let me know and I'll

[Archivesspace_Users_Group] Custom reports with string params?

2020-10-02 Thread Nick Butler
Hi all, We've been asked to create a custom report that allows the user running it to input a string which is then used to search across various fields. I've checked through the pre-existing reports, and through several reports created by other institutions, but I haven't found an example of a