bcgov / bcgov/foi-flow

Redash - Create Query showing list of Request #'s that have had Response Package created in FOI Mod

Open
#4,960 0 comments 0 reactions 0 assignees View on GitHub
Task
Dominant language
Python
Stars
8
Forks
2
Avg merge
14h 34m
Merged PRs (30d)
46

Description

#### Description

An IAO team has requested a query be created to show all requests in FOI Mod that have had a response package created in FOI Mod. The query would essentially just show these columns/values:

image.png

e.g.,
SELECT requestid, responsepackagecreated
FROM public."xxxxxxx"
WHERE responsepackagecreated = 'TRUE'

Response package creation in FOI Mod done through the action below:

image.png

I couldn't find the column indicating response package creation in our schema in Redash.

#### Dependencies
Are there any dependencies?

#### DOD
- [ ] Create query in Redash showing Request #'s that have had response package created in FOI Mod
- [ ]
- [ ]
- [ ]
- [ ]

Contributor guide

Open the contributing guide

Research direction

Start in Redash by inspecting the FOI Mod schema and available columns related to response package creation. Build a query returning requestid and the response-package-created value, filtered to created responses; done when it shows the requested Request #s and can be validated against FOI Mod records.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
analytics, databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.