How to query Parent/Child Datatypes in App State?

I'm using Supabase as database and I'm allowing users to create Parent rows, for which the user will also create child rows. This is straight forward with a database, as I can always list the Child rows referenced by the Parent ID.

Then I discovered Data Types in App States and with this method I could reduce database queries by at least 90% if I used a data structure that only lives on the device. My issue is that I can't figure out how to filter the Child rows of a Parent row in a Listview. Context: I know how to use nested listviews, but in my case, I display them in separate views.

Summary: How can I list Child rows of a specific Parent row?

1
2 replies