mongo java 根据if条件addFields

最新推荐文章于 2024-01-02 22:56:11 发布

原创最新推荐文章于 2024-01-02 22:56:11 发布 · 357 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #开发语言 #服务器

mongo脚本：

db.collection1.aggregate([
    { 
        $addFields: {
            newColumn:{
              $cond: {
                  if: { $eq:["$query1", 1], $eq:["$query2", 2]},
                  then: "$find",
                  else: "not find"
        }}
        }
    }
])

java代码：

        AggregationOperation startDateSet = aoc -> new Document("$addFields", new Document("newColumn", new Document("$cond",
          new Document("if", new Document("$eq", Arrays.asList("$query1", 1)).append("$eq", Arrays.asList("$query2", 2)))
            .append("then", "$find").append("else", "not find")
        )));
        Aggregation aggregation = Aggregation.newAggregation(
          startDateSet,
          Aggregation.skip(pageSize * (pageNo - 1)),
          Aggregation.limit(pageSize)
        );