how to make a report for all attributes uploaded for a period of time for a collection

ArctosDB / arctos

Arctos is a museum collections management system

https://arctos.database.museum

60 stars 13 forks source link

how to make a report for all attributes uploaded for a period of time for a collection #7982

Open cjconroy opened 1 month ago

cjconroy commented 1 month ago

For the NSF Ranges project, it would be helpful for our reporting to be able to query arctos via SQL to ask how many attributes were uploaded during a period of time, perhaps also the number of specimens affected, or limit by user? We are also keeping track with each upload, but this would be a good check on that. Thanks.

mkoo commented 1 month ago

Sure- this looks like a SQL request first so we can get to this next week

dustymc commented 1 month ago

Attributes do not currently carry those data. Metadata could be added, I would need details regarding what information is needed to craft a proposal.

cjconroy commented 1 month ago

I looked at activity under the person who has been uploading attributes and it is not recorded. If you look on a record that has had attributes bulk loaded, it notes the user is DBA. Why not the agent? In other cases an agent name is shown (data entry?) or part edits (user name). I think I have complained about this before in that that list shows dozens of dba entries that tell a user nothing useful. AND, on Chrome grabbing the edge or corner of the box to expand it just makes it disappear.