Report requests (Break out reports into their own issues)
Please add the item holding institution (holding_institution_ids or dcterms_provenance) to the Collections' Items report.
Please add the collection holding institution (holding_institution_ids) to to the Repositories' Collections report.
We'd like the following new reports:
-
1. Link report, List of harvested urls -> FROM items table WHERE local=false, Csv should include record_id, edm_is_shown_at -
2. Items with full text, list of items with full text, fields include portal, collection, and provenance -> FROM items table WHERE fulltext=ISNOTBLANK, Csv should include record_id, dcterms_provenance, collection, portal. See issue #438 (closed) -
3. Items with pages, list of items with iiif images, fields include portal, collection, and provenance -> FROM items table WHERE pages>0, Csv should include record_id, dcterms_provenance, collection, portal. See issue #440 (closed). -
4. Sheila would like subjects per holding institution, this would look like a list of all subjects in records for a single dcterms_provenance as many times as they appear rather than an aggregate count (if they have Books
in 1000 records it should appear 1000 times on the list). I'm not sure the logic on this one. -
5. Missing thumbnails, list of items without thumbnails -> FROM items table WHERE thumbnail=false, Csv should include record_id, edm_is_shown_at **I'm not sure it will do what I am expecting (and want), which is to return records missing thumbnails. I don't know where the value comes from. We don't provide it.
Edited by Josh Wier