How do I query a subcollection in Firestore

sasha-alias / sqltabs

Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift, Google Firebase (Firestore)

https://www.sqltabs.com

GNU General Public License v3.0

805 stars 65 forks source link

Closed stuurman closed 3 years ago

stuurman commented 3 years ago

something like this does not seem to work: collection("restaurants").doc("123").collection("reviews").where('name', '==', 'something').select()

sasha-alias commented 3 years ago

Try this:

collection("restaurants/123/reviews")
.where('name', '==', 'something')
.select()

stuurman commented 3 years ago

works like a charm, thanks!