Flutterflow - Supabase mutli-filter backend query

example table schema in supabase

table_name

Item_id (UUID)

user_id

type

name

updated_at

123erefsdf3q4

user1UUID

blue

bird

2024-12-13 1200

1324rwefgf5

user2UUID

green

dog

2024-12-13 1300

134aergf6gw

user1UUID

yellow

cat

2024-12-13 1400

11123r23fasdf

user1UUID

blue

cat

2024-12-13 1500

On flutterflow, I will have something like:

On user1’s dashboard

container

row

column

bluecontainer

text (Blue)

text (Cat)

yellowcontainer

text (Yellow)

text (Cat)

greencontainer

text (green)

text (no data)

It will display the most recent type for each value under column type. There will be around 30 different “types” and i want to have the most recent row for each type, based on the user, display on the dashboard.

I'm struggling to get information from multiple rows, i can call information from one row, but cant seem to be able to get information from a list of rows

I've tried looking through documents on flutterflow and supabase, but couldn't find information on this with supabase queries

I've played around with putting the query in different locations. tried mapping the query to page state variable, played with different places to output the data (listview, dynamic children, different fields), tried various combinations with: map list items filter list items item at index first few items sort list items unique list items no further changes.

in test mode, I can see that my backend query is getting the information. (i even disabled RLS to see if that was the issue)

I've even tried chat Gpt to help, but it leads me around in circles

the answer must be simple, but i'm just not seeing it