This is my database structure.
cities -> landmarks -> attractions(each one is a collection)
Query
List all attractions under a particular city.
Solution
Save city_id in each attraction document
Use a collection group query and filter based on city_id to get attractions of a particular city.
My Question
Instead of saving city_id in each attraction document, can I just specify the document to the collectionGroupQuery which now only searches in subcollections under this particular document.
In the above example, I specify the city document's full path and i should be able to list all attractions without filtering based on city_id.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
