Repository - findBy<Field>IgnoreCase doesnt work [DATAMONGO-770]

[spring-projects-issues]

regis opened DATAMONGO-770 and commented

I create a simple user document with an email field,

 
@Document(collection = "user")
public class UserDocument {

    @Id
    private ObjectId id;

    private String status;
    private String firstname;
    private String lastname;

    @Indexed(unique = true)
    private String email;

   all getter/ setter provided

}

 

Here my repository

 
public interface UserRepository extends CrudRepository<UserDocument, ObjectId>, QueryDslPredicateExecutor<UserDocument> {
    UserDocument findByEmailIgnoreCase(String email);

}

 

its working - i find a user document with

 
UserDocument foundUser = repository.findByEmailIgnoreCase("[email protected]");

 

its NOT working - i dont find a user document with

UserDocument foundUser = repository.findByEmailIgnoreCase("[email protected]");

 

I also try with the firstname it also doesnt work

Here my logs

 
DEBUG o.s.d.m.c.MongoTemplate - findOne using query: { "email" : "[email protected]"} in db.collection: portfolio_test.user

 

I m using spring-data-mongodb 1.3.1
mongodb 2.4.6
open jdk 7

I try to debug but it is in spring-data-common where it is handle the findBy stragegy lookup

PS: right now im using Query DSL to handle this

 
QUserDocument userDocument = new QUserDocument("userdocument");
return userRepository.findOne(userDocument.email.equalsIgnoreCase(email));

 

---

Affects: 1.3 GA, 1.3.1

Referenced from: commits e8a303b, fe41202

[spring-projects-issues]

regis commented

The bug seems to be there since 1.2.x

http://forum.spring.io/forum/spring-projects/data/nosql/124545-how-describe-mongodb-regex-ignorecase-query-using-interface-method-name

[spring-projects-issues]

regis commented

Whats happening ? Do you need unit test ?

[spring-projects-issues]

Oliver Drotbohm commented

IgnoreCase is currently not supported at all. We're going to include that in the first milestone of the upcoming release train Codd

[spring-projects-issues]

regis commented

It should be great to specify in documentation what is supported like in jpa data
http://docs.spring.io/spring-data/jpa/docs/1.4.1.RELEASE/reference/htmlsingle/#d0e2609

[spring-projects-issues]

Thomas Darimont commented

Added PR: #78

[spring-projects-issues]

Thomas Darimont commented

Please revise

[ps-tunnelsoft]

Oliver Drotbohm commented

IgnoreCase is currently not supported at all. We're going to include that in the first milestone of the upcoming release train Codd

I could not find the IgnoreCase query keyword in the documentation and I wonder what happened with this feature request in the milestone

[christophstrobl]

@ps-tunnelsoft the Codd release train has reached EOL already quite some time ago. You can find supported keywords (may vary depending on the store implementation) in the appendix.

[ps-tunnelsoft]

@christophstrobl I just tested it and IgnoreCase keyword works but it isn't in the list of supported keywords

[christophstrobl]

I see - it's missing in the Query Methods section of the reference documentation. Created #3916 for this. Thanks!