arctos icon indicating copy to clipboard operation
arctos copied to clipboard

Request - Create new reports for OGL summary data

Open falco-rk opened this issue 4 months ago • 0 comments

Help us understand your request (check below):

  • [x] search or data request (help with SQL or provide the specific fields you are trying to retrieve for your collection)
  • [ ] add a new Github user to the Arctos Users team
  • [ ] a new barcode series
  • [ ] a new term for data entry or management
  • [ ] a change or new report or label
  • [ ] update to an Agent (split, merge, or other type of change)
  • [ ] bulkload changes (to Agents, Identifiers, etc that are not already available as a bulkloading tool)
  • [ ] new feature or otherwise a good idea to make Arctos even better
  • [ ] quarantine taxon name and suggested replacement (please supply links)
  • [ ] other

Describe what you're trying to do

  1. Can you create an Accession Report that gives me data based on a list of queried accessions? I would like it to give me all the data that is in the "Accessions by Month" section of the "OGL Monthly Report Stats" Report (with the edits I have asked for here).
  2. Can you create an OGL Taxa Report that gives me the count of unique taxa based on the catalog records within a list of queried accessions and how many of those are new to the OGL collection?
  3. Can you create a Collection Location Report that gives me data base on a list of queried accessions? I want: (1) Lat/long coordinates, (2) higher geography, and (3) specific locality.
  4. Can you create a Loan Report that gives me data based on a list of loans? I would like it to give me all the data that is in the "Loans by Month" section of the "OGL Monthly Report Stats" Report.

@happiah-madson @dustymc

falco-rk avatar Oct 02 '24 16:10 falco-rk