My Firestore database has the following architecture :
users :
[user_id1] :
list :
[list_id1] :
count : [int]
title : [String]
...
[list_id2]...
[list_id3]...
[user_id2]...
[user_id3]...
I'm trying to query all the items contained in every list and order them by count.
Is there a way to do this with one or two requests ? (using Transaction)
PS: I created another collection at the root of my Firestore database which contains [user_id] and [list_id] for every list of the database.