我试图在firestore中动态查询〈=和〉=操作符。这意味着我想动态地添加每个键和值到查询中，但我得到一个错误，它不会在firebase上工作。
所有包含不等式（〈、〈=、〉或〉=）的where筛选器必须位于同一字段上。但您在“FieldPath（[price]）”和“FieldPath（[meter]）”上具有不等式筛选器。“package：cloud_firestore/src/query. dart”：Assert失败：第780行位置13：'具有不等式==字段'
我的代码：

class HomePage extends StatefulWidget {

  @override
  _HomePageState createState() => _HomePageState();
}

class _HomePageState extends State<HomePage> {
  late Query _query;
  final Map<String, dynamic> _filters = {
    'price': 500,
    'meter': 120,
  };
@override
  void initState() {
    super.initState();
    _query = FirebaseFirestore.instance.collection('items');
    for (var key in _filters.keys) {
      if (_filters[key] != null) {
        _query = _query.where(key, isGreaterThanOrEqualTo: _filters[key]);
      }
    }
  }
@override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: const Text('My App'),
      ),
      body: StreamBuilder<QuerySnapshot>(
        stream: _query.snapshots(),
        builder: (BuildContext context, AsyncSnapshot<QuerySnapshot> snapshot) {
          if (!snapshot.hasData) {
            return const CircularProgressIndicator();
          }
          List<DocumentSnapshot> documents = snapshot.data!.docs;
          return ListView.builder(
            itemCount: documents.length,
            itemBuilder: (BuildContext context, int index) {
              DocumentSnapshot document = documents[index];
              return ListTile(
                title: Text('${document['price']}'),
                subtitle: Text(
                    '${document['meter']} m² / ${document['landMeter']} m²'),
              );
            },
          );
        },
      ),
    );
  }
}

有没有办法解决这个限制？或者动态查询？