Spring Data MongoDB：在多个字段上进行类似搜索

Answer 1

您可以使用$expr(3.6mongo版本操作符）在常规查询中使用聚合函数，仅用于精确匹配。

Spring@query代码

@Query("{$expr:{$eq:[{$concat:["$Firstname","$Lastname"]}, ?0]}}")
ReturnType MethodName(ArgType arg);

对于find like searches或Access search，您必须在较低版本中通过mongo模板使用聚合。

AggregationOperation project = Aggregation.project().and(StringOperators.Concat.valueOf("Firstname").concatValueOf("Lastname")).as("newField");

AggregationOperation match = Aggregation.match(Criteria.where("newField").regex(val));

AggregationOperation match = Aggregation.match(Criteria.where("newField").is(val));

 Aggregation aggregation = Aggregation.newAggregation(project, match);
 List<BasicDBObject> basicDBObject =  mongoTemplate.aggregate(aggregation, colname, BasicDBObject.class).getMappedResults();