Due to limitations of the com.mongodb.BasicDocument, you can‘t add a second ‘null‘ criteria. Query a

这个问题出现的原因是上面两处创建的criteria,没有指定key,所以都是默认null。

1. 修改方案一

// Start with a clean query
Query query = new Query();

// Handle time criteria
if (liveRoomReq.getStartTime() != null && liveRoomReq.getEndTime() != null) {
    Criteria timeCriteria = new Criteria();
    timeCriteria.orOperator(
            Criteria.where("broadcastTime").lte(liveRoomReq.getEndTime())
                    .andOperator(Criteria.where("broadcastTime").gte(liveRoomReq.getStartTime())),
            Criteria.where("planBroadcastTime").lte(liveRoomReq.getEndTime())
                    .andOperator(Criteria.where("planBroadcastTime").gte(liveRoomReq.getStartTime()))
    );
    query.addCriteria(timeCriteria);
} else if (liveRoomReq.getStartTime() != null) {
    Criteria timeCriteria = new Criteria();
    timeCriteria.orOperator(
            Criteria.where("broadcastTime").gte(liveRoomReq.getStartTime()),
            Criteria.where("planBroadcastTime").gte(liveRoomReq.getStartTime())
    );
    query.addCriteria(timeCriteria);
}

// Handle fallback criteria
if (StringUtil.isNotEmptyString(liveRoomReq.getFallback())) {
    if ("0".equals(liveRoomReq.getFallback())) {
        // Create a named criteria instead of using a criteria without a field name
        Criteria fallbackCriteria = new Criteria("$or");
        fallbackCriteria.is(Arrays.asList(
                new BasicDBObject("fallback", new BasicDBObject("$in", Arrays.asList(liveRoomReq.getFallback()))),
                new BasicDBObject("fallback", new BasicDBObject("$exists", false))
        ));
        query.addCriteria(fallbackCriteria);
    } else {
        query.addCriteria(Criteria.where("fallback").is(liveRoomReq.getFallback()));
    }
}

2. 修改方案二

// 创建一个新的查询对象
Query query = new Query();

// 创建列表来保存我们的条件
List<Criteria> andConditions = new ArrayList<>();

// 处理广播时间条件
if (liveRoomReq.getStartTime() != null && liveRoomReq.getEndTime() != null) {
    Criteria broadcastTimeCriteria = new Criteria().orOperator(
        Criteria.where("broadcastTime").lte(liveRoomReq.getEndTime())
            .andOperator(Criteria.where("broadcastTime").gte(liveRoomReq.getStartTime())),
        Criteria.where("planBroadcastTime").lte(liveRoomReq.getEndTime())
            .andOperator(Criteria.where("planBroadcastTime").gte(liveRoomReq.getStartTime()))
    );
    andConditions.add(broadcastTimeCriteria);
}

// 处理fallback条件
if (StringUtil.isNotEmptyString(liveRoomReq.getFallback())) {
    if ("0".equals(liveRoomReq.getFallback())) {
        Criteria fallbackCriteria = new Criteria().orOperator(
            Criteria.where("fallback").in(liveRoomReq.getFallback()),
            Criteria.where("fallback").exists(false)
        );
        andConditions.add(fallbackCriteria);
    } else {
        andConditions.add(Criteria.where("fallback").is(liveRoomReq.getFallback()));
    }
}

// 如果有多个条件，则使用AND组合所有条件
if (andConditions.size() > 1) {
    query.addCriteria(new Criteria().andOperator(andConditions.toArray(new Criteria[0])));
} else if (andConditions.size() == 1) {
    query.addCriteria(andConditions.get(0));
}