Flutter Firestore设置orderBy descending为true时触发异常求助

在Flutter项目中使用Firestore查询数据时，按date字段**降序（descending: true）排序会触发异常，但设为升序（descending: false）**时查询可正常运行。

查询代码 #

final snapshots = firebaseFirestore.collectionStream(
  path: ridesCollectionPath,
  queryBuilder: (query) => query
      .where(
        Filter.and(
          Filter("userId", isEqualTo: userId),
          Filter.or(
            Filter("date", isLessThan: DateTime.now()),
            Filter("cancelled", isEqualTo: true),
          ),
        ),
      )
      .orderBy('date', descending: true),
);

异常信息 #

I/flutter (24875): Error: #0 EventChannelExtension.receiveGuardedBroadcastStream (package:_flutterfire_internals/src/exception.dart:67:43)
I/flutter (24875): #1 MethodChannelQuery.snapshots. (package:cloud_firestore_platform_interface/src/method_channel/method_channel_query.dart:183:18)

I/flutter (24875): Error: #0 EventChannelExtension.receiveGuardedBroadcastStream (package:_flutterfire_internals/src/exception.dart:67:43)
I/flutter (24875): #1 MethodChannelQuery.snapshots. (package:cloud_firestore_platform_interface/src/method_channel/method_channel_query.dart:183:18)

可能的原因及解决方法 #

• 缺少复合查询索引
  Firestore的复合查询（同时用where和orderBy）需要对应索引，升序和降序可能需要单独创建。运行查询后，Firebase控制台或IDE日志会给出索引创建的直接链接，点击跳转创建包含userId、date（降序）的复合索引即可。

• date字段数据异常
  检查集合内所有文档的date字段，确保统一为DateTime类型，无null或其他类型值。如果允许null，需在查询中添加Filter("date", isNotEqualTo: null)明确处理。

• Filter组合逻辑冲突
  当前Filter.or包含两个条件，这种场景下的排序可能需要更复杂的索引覆盖。可以拆分查询后合并结果：

  // 查询已过期的行程
  final pastRides = firebaseFirestore.collectionStream(
    path: ridesCollectionPath,
    queryBuilder: (query) => query
        .where("userId", isEqualTo: userId)
        .where("date", isLessThan: DateTime.now())
        .orderBy('date', descending: true),
  );
  // 查询已取消的行程
  final cancelledRides = firebaseFirestore.collectionStream(
    path: ridesCollectionPath,
    queryBuilder: (query) => query
        .where("userId", isEqualTo: userId)
        .where("cancelled", isEqualTo: true)
        .orderBy('date', descending: true),
  );
  // 合并两个流并重新排序去重
  final combinedSnapshots = StreamZip([pastRides, cancelledRides]).map((lists) {
    final merged = [...lists[0], ...lists[1]];
    merged.sort((a, b) => b['date'].compareTo(a['date']));
    // 可选：根据文档ID去重
    return merged.toSet().toList();
  });
  

• FlutterFire版本问题
  旧版cloud_firestore可能存在降序排序的bug，执行flutter pub upgrade cloud_firestore升级到最新稳定版后重试。

内容的提问来源于stack exchange，提问作者DeKekem