Alex Rivera | Logout

spring MongoRepository Query regex

Asked 2013-05-24T07:26:24.650
9

I´m looking to use a regular expresion using MongoRepository inside a Query annotation. The only information that I found so far is a Chinese post but do not explain how make it works, and I´m not sure if is what I´m looking for.

@Query("{ 'name':{'$regex':?2,'$options':'i'}, sales': {'$gte':?1,'$lte':?2}}") public Page findByNameAndAgeRange(String name,double ageFrom,double ageTo,Pageable page);

Somebody know if it possible use a specific regex in the query?

Regards.

java spring-data spring-data-mongodb
Edit
Report

1 Answer

16

i toggles case insensitivity, and allows all letters in the pattern to match upper and lower cases.

Read more about $regex in MongoDB docs.

In your query it looks like you have mixed up something with parameters order (?2 in name regex). I believe it should be:

@Query("{ 'name':{$regex:?0,$options:'i'}, 'sales': {$gte:?1,$lte:?2}}") 
public Page findByNameAndAgeRange(String name,double ageFrom,double ageTo,Pageable page);
answered 2013-05-24T08:34:40.703

Your Answer