Firebase条件在其中

Question

QuerySnapshot querySnapshot = await FirebaseFirestore.instance
.collection('stations')
.where('norequest', isGreaterThan: 9)
.get();

这里我想得到如果'norequest'是一个整数，像10,20,30,40这样的东西，大于5 ?我怎样才能得到那个

Answer 1

Future<List<YourModel>> getData() async {
List<YourModel> yourModel = [];
QuerySnapshot querySnapshot =
await FirebaseFirestore.instance.collection('stations').where("norequest", isGreaterThan: 5).get();
if (querySnapshot?.docs != null) {
querySnapshot.docs.map((x) {
if (int.parse(x.data()['norequest'].toString()) % 10 == 0) {
yourModel.add(YourModel.fromJson(x.data()));
}
});
}
return yourModel;
}

Answer 2

try this query:

QuerySnapshot querySnapshot = await FirebaseFirestore.instance
.collection('stations')
.where('norequest', isGreaterThan: 5)
.where("norequest", whereIn: [10, 20, 30, 40])    
.get();