How to get a sub collection after using .where in flutter

manpreet Best Answer 3 years ago

I was wondering if there was a way of getting a sub collection after using .where

This is my database format

• Users <-- collection
• Bob123
• posts <-- sub collection
• post1

Firestore.instance.collection("Users")
.where("followers", arrayContains: id)  //id is the users">users id 
//He i want to get the collection of posts that the particular user has posted

manpreet 3 years ago

Subcollections are under an individual document, while a query identifies a group of documents. If when you know that the query only identifies one document, the Firestore client doesn't know that, and even if it did, it doesn't know the full path for that document.

You first need to execute the query, then get the individual documents, and then you can get the subcollection of each document.