...
All queries:
- [ ] PR Title and Description are accurate and thorough
- [ ] PR is based on a new branch (not main)
- [ ] PR scope is not overly broad
- [ ] Query runs without errors
- [ ] Query output is correct
- [ ] Query logic is clear and well documented
- [ ] Query is readable and properly indented with spaces (not tabs)
- [ ] Table and column names are in all-lowercase
- [ ] Quotation marks are used only where necessary
Report queries:
- [ ] Query has complete user documentation
- [ ] Purpose of report
- [ ] Sample output
- [ ] Query instructions
Documenting your query
-each query needs a CR or AHR number
-name of query
-query reviewer, query writer
-date posted/updated
-short description of what query does
Related Resources
https://github.com/folio-org/folio-analytics/blob/main/QUERIES.md
...