说我在mongo文档中有一个多值字段:
public class MongoEntity{
private List<String> field;
}
在该字段中查询正则表达式的正确标准是什么?
我已经试过了
Criteria.where(searchText).regex(searchText).in("field");
但这会导致
org.springframework.data.mongodb.UncategorizedMongoDbException:
Can't canonicalize query: BadValue unknown top level operator: $in;
nested exception is com.mongodb.MongoException: Can't canonicalize query: BadValue unknown top level operator: $in
所以经过多次尝试和错误,结果比它想象的要简单(尽管在我看来有点违反直觉):
Criteria.where("field").regex(searchText);
这很管用
List<Pattern> regs = new ArrayList<Pattern>()
regs.add(Pattern.compile(regex, Pattern.CASE_INSENSITIVE))
Criteria.where("tags").regex(regs)