Firestore query with multiple filters
Using Dart/Flutter and the package firebase_storage
: ^11.7.7, I am building the method getQuestions
that receives the following parameters below. I need to search for questions in the database using these filters that can be null
, considering that they are lists coming from multiple selects and firestore does not accept multiple where in
, what is the best solution for this problem, since the limit
in a first search can harm the filtering if done locally and if the limit
parameter is removed the search can be very costly because there are millions of questions records in the database?