<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">On second thought, if you’re not adept with JSON tools, then exporting as CSV and loading in EXCEL to sort and group by created_by might be an easier solution. <div class=""><br class=""></div><div class="">And the missing translation errors don’t show up in the CSV: </div><div class=""><br class=""></div><div class="">repository,Albert and Shirley Small Special Collections Library<br class=""><br class="">record_title,identifier,level,resource_type,publish,restrictions,created_by,create_time,date,extent<br class="">Jack R. Levien papers,MSS 15241,Collection,,Yes,No,admin,2015-08-11 21:43:13 UTC,"[{""_date"":""Creation: 1960 - 1999, 1960-1999""}]","[{""portion"":""Whole"",""container_summary"":""2 document boxes"",""physical_details"":null,""dimensions"":null,""extent"":""0.80 Cubic Feet""}]"<br class="">George family papers,MSS 13543,Collection,Papers,Yes,No,admin,2015-08-11 21:43:17 UTC,"[{""_date"":""Creation: 1816 - 1963, 1816-1963""}]","[{""portion"":""Whole"",""container_summary"":""1 document box"",""physical_details"":null,""dimensions"":null,""extent"":""0.50 Cubic Feet""}]"<br class="">Francis Burton Harrison papers,MSS 14969,Collection,Papers,Yes,No,admin,2015-08-11 21:43:21 UTC,"[{""_date"":""Creation: 1921 - 1945, 1921-1945""}]","[{""portion"":""Whole"",""container_summary"":""1 document box"",""physical_details"":null,""dimensions"":null,""extent"":""0.50 Cubic Feet""}]"<br class="">Holmes family papers,MSS15167,Collection,,Yes,No,admin,2015-08-11 21:43:24 UTC,"[{""_date"":""Creation: 1766 - 1928, 1908-1975; 1766-1928""}]","[{""portion"":""Whole"",""container_summary"":""4 Hollinger boxes"",""physical_details"":null,""dimensions"":null,""extent"":""934.00 items""}]"<br class="">Theron H. Rice papers,MSS15247,Collection,,Yes,No,admin,2015-08-11 21:43:28 UTC,"[{""_date"":""Creation: 1877 - 1923, 1877-1923""}]","[{""portion"":""Whole"",""container_summary"":""1 Hollinger box"",""physical_details"":null,""dimensions"":null,""extent"":""70.00 items""}]"<br class="">Benjamin C. Howland papers,MSS 13748,Collection,,Yes,No,admin,2015-08-11 21:43:31 UTC,"[{""_date"":""Creation: 1941 - 1983, 1941-1983""}]","[{""portion"":""Whole"",""container_summary"":""6 Hollinger boxes"",""physical_details"":null,""dimensions"":null,""extent"":""757.00 items""}]"</div><div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Dec 9, 2020, at 12:42 PM, Majewski, Steven Dennis (sdm7g) <<a href="mailto:sdm7g@virginia.edu" class="">sdm7g@virginia.edu</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""><br class=""></div>You can just add created_by and create_time ( and perhaps other fields like: last_modified_by, finding_aid_author ) to the resource_list_report.rb :<div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(223, 189, 34); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">diff --git a/reports/resources/resources_list_report/resources_list_report.rb b/reports/resources/resources_list_report/resources_list_report.rb</b></span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(223, 189, 34); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">index 96f200fed..ad3a96474 100644</b></span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(223, 189, 34); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">--- a/reports/resources/resources_list_report/resources_list_report.rb</b></span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(223, 189, 34); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><b class="">+++ b/reports/resources/resources_list_report/resources_list_report.rb</b></span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #4ed2e0" class="">@@ -9,7 +9,8 @@</span><span style="font-variant-ligatures: no-common-ligatures" class=""> class ResourcesListReport < AbstractReport</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> level_id as level,</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> resource_type_id as resource_type,</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> publish,</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(86, 0, 1); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">- restrictions</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures; color: #50db39" class="">+</span><span style="font-variant-ligatures: no-common-ligatures" class=""> </span><span style="font-variant-ligatures: no-common-ligatures; color: #50db39" class="">restrictions,</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(80, 219, 57); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">+ created_by, create_time</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> from resource</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> where repo_id = #{db.literal(repo_id)}"</span></div><div style="margin: 0px; font-stretch: normal; font-size: 17px; line-height: normal; color: rgb(205, 190, 151); background-color: rgba(122, 37, 30, 0.85);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> end</span></div><div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div class=""><br class=""></div><div class="">And add those to the .yml files in that directory, otherwise you will get something like:</div><div class=""><br class=""></div><div class=""><dt style="float: left; padding: 0px; font-weight: bold; margin-right: 10px; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;" class="">translation missing: en.reports.translation_defaults.created_by</dt><dd style="margin: 2px; padding: 0px; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;" class="">admin</dd><dt style="float: left; padding: 0px; font-weight: bold; margin-right: 10px; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;" class="">translation missing: en.reports.translation_defaults.create_time</dt><dd style="margin: 2px; padding: 0px; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;" class="">2015-08-11 21:43:13 UTC</dd><div class=""><br class=""></div><div class="">( And we really should add a translation missing fallback to these reports to make customizing easier! ) </div></div><div class=""><br class=""></div><div class="">That doesn’t make it easily sortable however. That would take more work. </div><div class="">Alternatively, once you have added those fields, you can use the json output format, and write a script, or use ‘jq’ to sort, group, and format the report before printing. However, if you need to group by author, it might just be simpler to run the report outside of archivesspace as a mysql query. </div><div class=""><br class=""></div><div class="">If you wanted that sort of grouping as an ArchivesSpace report, you would need to write a new report, restructuring it as a subreport on resources created by each user. </div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">— Steve M.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><blockquote type="cite" class=""><div class="">On Dec 8, 2020, at 6:51 PM, Cornwall, Daniel D (EED) <<a href="mailto:daniel.cornwall@alaska.gov" class="">daniel.cornwall@alaska.gov</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Hello,<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">After fiddling with the reports module in 2.8 and looking at the documentation in ArchivesSpace help center I want to ask you if your institution keeps track of the number of finding aids that someone enters into ArchivesSpace and if so, how you track that. The Resources List Report ALMOST fits my purposes but doesn’t list the audit information I’d need to filter when resource records were created or modified.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">If you’re aware of this kind of functionality, or ideally a report that would produced a list of resource records with creation date by users, please let me know. Otherwise I’ll think about other ways to track.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Thanks! - Daneil<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">==============================<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Daniel Cornwall<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Library Technology Consultant / OWL Program Manager<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Alaska State Library<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Ph: 907-465-6332<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><a href="https://lam.alaska.gov/daniel" class="">https://lam.alaska.gov/daniel</a><o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Archivesspace_Users_Group mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="font-family: Menlo-Regular; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></div></blockquote></div><br class=""></div></div>_______________________________________________<br class="">Archivesspace_Users_Group mailing list<br class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class=""></div></blockquote></div><br class=""></div></body></html>