Set Choice Chip and List view values from Supabase query

I have a page with a choice chip widget and a list view. I want to populate both the choice chip and list view values from the same supabase query and have the listview values filtered by the selected choice chip value. The data for both are in the same table. I tried running a backend query on the scaffold page but then I can't set the values for the choice chip options or the list view test values. When I try and set those values all I get are some options to filter the list, map the list items, etc... Is this possible or do I need to run two backend queries to the same table, one for the choice chips and another one for the listview?

3