Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

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
So after many trial and errors, turns out it's simpler (although a little counter-intuitive in my opinion) than it thought:
Criteria.where("field").regex(searchText);
                this is not working for me. I have List<String> tags and want to search with searchStr                       I have code like this      String regex = ".*" + searchText + ".*";  Criteria.where("tags").regex(regex). But this is not giving results.
– user3863488
                Aug 23, 2020 at 16:05
This is working
List<Pattern> regs = new ArrayList<Pattern>()
regs.add(Pattern.compile(regex, Pattern.CASE_INSENSITIVE))
Criteria.where("tags").regex(regs)
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.