How to query several subcollections from collections references

Database & APIs

Hi guys,

I got a doubt, I'm following a chatgpt suggestion about separate some information in my firestore table, I have the information about an order and its products detail in a subcollection (because there are too many fields for each order).

So I'm trying to show to an user a list of orders with the order information but I need to do double query on flutterflow, one for the collection and another one for the subcollection, but I can't get work the subcollection query because the reference, how I can pass the list of rerence from the first query output?.


I watched this video on the docs but it just show how to query subcollection for a single reference not for a list. ๐Ÿ˜•


https://www.loom.com/share/e069c07b5dd14b228099534464997bca?sid=c055bcba-9fc5-4a63-8d34-eb45e6c09c09



Thanks in advance.

What have you tried so far?

I've tried passing the reference list directly from the output of the first query and tried to store the output from the first query into a pagestate and pass to the subcollection query but it doesn't work.

Did you check FlutterFlow's Documentation for this topic?
Yes
2