Redash - Create Query showing list of Request #'s that have had Response Package created in FOI Mod
- 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:

e.g.,
SELECT requestid, responsepackagecreated
FROM public."xxxxxxx"
WHERE responsepackagecreated = 'TRUE'
Response package creation in FOI Mod done through the action below:

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
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