How to open a modal and show table of certain records

I’m new to Wappler and am at a loss here…

Setup
I have a data table with 250+ chapters. Each record in the table has a two character state abbreviation field, a chapter name field, and several other fields.

What I want to do
On a webpage when the appropriate state button is clicked I want to open a modal that displays all chapter records only for the desired state.

I have a query built that works using a $GET variable for the state and displays appropriate data for that state on the main page. I’m not sure how to proceed to modify the query (or add a new one) such that it will insert the appropriate state value that comes from the clicked button into a query, opens a modal, and executes the query showing all records for the desired state.

I’ve searched and searched but cannot seem to find the answers I need. Ideally the solution would be in tutorial format, showing step-by-step directions.

Please help!

Thanks.