💬
Get Help
AL
Argenis Leon

Query a List view to search data from another collection using doc reference

Database & APIs

Hi there!

I have seller collection and statements_of_work collection in firebase.

In seller collection i have a document reference list that points to documents from statemeents_of_work collection.

Capture.PNG
8.78KB

I need to make the listView to loop trough statements_of_work collection but only displaying the ones listed in seller collection docRef list

SOW.PNG
22.76KB

It should be a really common case scenario but i can't find anything related in docs neither the community, i found some post but they didn't work for me.

The idea is just to display every seller's statements_of_work info. here i show a failed attempt with a pen correction. I just need these two, not every SOW.

SOWw.PNG
45.11KB

I hope you can help me, and thanks.

What have you tried so far?

  • Query SOW collection and trying to filter using sellers doc ref list. (didn't work because i only can filter the SOW values and not the reference.

  • Using query document from reference, and i just manage to get one value correctly because i only can use Item at index but i need every value.

    SOW filter.PNG
    69.2KB

  • Quering SOW collection and then generating children from variable inside a column. In theory this is my best bet but i can't manage to filter because that filter list loop isn't even documented in flutterflow.

    valuee.PNG
    37.19KB

    Here i try to filter the list but i'm just loosing the battle.

    hell.PNG
    73.81KB

Did you check FlutterFlow's Documentation for this topic?
Yes
6
10 replies