portagenetwork / roadmap

Developed by the the Alliance in collaboration with University of Alberta, DMP Assistant a data management planning tool, forking the DMP Roadmap codebase
MIT License
6 stars 1 forks source link

Feature request: Build Automated Reporting #816

Open nmacgreg opened 3 months ago

nmacgreg commented 3 months ago

For the last few months, Marcus has been asking for some end-of-month data from the Production database, to help him fill out a report he's preparing for the Alliance. For the end of May and June, 2024, the results from these queries satisfied his needs:

select count(*) from plans;
select count(*) from users;
select count(*) from orgs where managed=true;

This list has been growing and changing over time. This may continue to change, so we need Marcus to generate requirements for this new feature.

All I know is, "Marcus needs data". I don't know whether we should create a reporting UI, give him a direct query interface to the database, or write 5 lines of shell-script called from cron. I'm creating this Issue to officially kick off the conversation!