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

[KyEggleston]

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
• [ ]
• [ ]
• [ ]
• [ ]