PostgreSql reporting

RichardCollette · September 13, 2024, 7:08pm

With all the export issues seemingly resolved now, I’ll drop a little nugget here for advanced users familiar with databases.

This is a database that I use to help me determine the requirements having the most need so that we can target our efforts. There are several other views as well.

I also have some BlackDuck views that could be helpful for importing rosters into BlackDuck.

This is not for novices, and I can’t really offer support. If you are a developer and want to contribute something back to the gist, let me know.

I use DBeaver to do the file imports

gist.github.com

https://gist.github.com/rcollette/996938b0ec6b1fadb29ce4823e1ec131

TargetedRankRequirementsReport.sql

-- Create a database in PostgreSQL

-- Apply this SQL to the dabase, using the command:
-- psql -d theDatabaseName -f TargetedRankRequirementsReport.sql

-- Import the Scoutbook exported troop roster into the scouts table first.
-- Import Scoutbook exported rank requirements into the rank_requirements table second.

-- Run various views to get "Reports". The view scout_requirements_targeted_all_scouts is probably of the most
-- interest and can be further filtered to target your needs.

This file has been truncated. show original