At the same time as
in queries Google also introduced
array-contains-any. Our company has had a need for
in queries in Retool, not yet for
array-contains-any, but I could definitely imagine we will in the future.
The use-case in which we'd like to use
in queries: we'd like to list all documents in a
Reports collection where the document's
state field is set to
READY FOR PROCESSING or to
.where("state", "in", ["READY FOR PROCESSING", "READY FOR REVIEW"]).
If the list of states is static (hard-coded) a workaround in Retool is to have separate queries and combine them in tables with
query1.data.concat(query2.data). That's unpleasant because we need to maintain
N practically-identical queries for
N states to follow. In addition, I'm not aware of any available workaround for when the list of states is dynamically generated.
We'd appreciate support for Firestore's
in queries in Retool!