I think you should try the thing listed down below in your MongoDB(I am assuming you have a User pojo class):
By using MongoTemplate
i option for case insensitive:
Criteria regex = Criteria.where("username").regex(".*ab.*", "i");
mongoOperations.find(new Query().addCriteria(regex), User.class);
Using MongoRepository (Case sensitive)
List<User> users = userRepository.findByUserNameRegex(".*ab.*");
interface UserRepository extends MongoRepository<User, String> {
List<User> findByUserNameRegex(String userName);
}
Using MongoRepository with Query dsl (Case sensitive)
List<User> users = userRepository.findByQuery(".*ab.*");
interface UserRepository extends MongoRepository<User, String> {
@Query("{'username': {$regex: ?0 }})")
List<User> findByQuery(String userName);
}
Now, case insensitive search/sort can be utilized through collation for non-regex query with locale and strength set to primary or secondary:
Query query = new Query(filter);
query.collation(Collation.of("en").
strength(Collation.ComparisonLevel.secondary()));
mongoTemplate.find(query,clazz,collection);