Getting null value while using @Query of spring data from mongo

Question

I have been querying mongodb using mongorepository and spring data.

My function looks like this:

@Repository
public interface UserRepository extends MongoRepository<User,String> {
    @Query(value="{'email' : ?0}")
    User findByEmail(String email);
}

My collection in mongodb looks like this

> db.user.find();
{ "_id" : "1", "email" : "[email protected]", "password" : "$2a$12$lDJgMZNLAcxv2J.QTZSjAuWJdPleBxXq.M4aj9itrR1RMDkgmwN7m", "name" : "def", "active" : 1, "isLoacked" : false, "isExpired" : false, "isEnabled" : true, "_class" : "com.x.gateway.auth.User" }

It always returns null value.

Try to use List<User> may be email is not a unique field at all. — Eklavya
– Eklavya, Commented Apr 16, 2020 at 14:47
@AbinashGhosh Your suggestion worked ` public interface UserRepository extends MongoRepository<User,String> { //@Query(value="{'email' : ?0}") List<User> findByEmail(String email); } ` Thanks man. Now will try to make the field unique. If you got any cheatsheet on db schema standards in mongo please attach it would be great help in this topic. — souradeep majumdar
– souradeep majumdar, Commented Apr 16, 2020 at 15:14

Eklavya · Accepted Answer · 2020-04-16 15:21:12Z

1

Since email is not a unique property, multiple users can be fetched. So map the method to List<User>.

@Query(value="{'email' : ?0}")
List<User> findByEmail(String email);

Offical doc, here you can find more details.

answered Apr 16, 2020 at 15:21

Eklavya

18.6k4 gold badges33 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eklavya Over a year ago

In official doc 6.3 Query methods is all about different query method.

Eklavya Over a year ago

if you find any solution helpful try to upvote it also

Alien · Accepted Answer · 2020-04-15 20:02:23Z

0

Why are you using

@Query(value="{'email' : ?0}")

As email is the direct field (Not nested) , only

User findByEmail(String email);

is enough and should work.

answered Apr 15, 2020 at 20:02

Alien

16k8 gold badges43 silver badges64 bronze badges

3 Comments

souradeep majumdar Over a year ago

@Alien : i had commented the annotation still no luck

souradeep majumdar Over a year ago

@AbinashGhosh : i had used email :[email protected] for querying

Alien Over a year ago

Ok then check you have only one record with this email in your db + Repository is autowired properly in service or controller class.

Collectives™ on Stack Overflow

Getting null value while using @Query of spring data from mongo

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related