Write custom query in mongodb repository

Question

I am writing custom query in mongo repository like this :

public interface AuthenticationTokenRepository extends MongoRepository<AuthenticationToken, String> 
{

    AuthenticationToken save(AuthenticationToken token);

    AuthenticationToken findByToken(String token);

    @Query("{'user.username' : ?0}")
    AuthenticationToken findByUserId(String username);
}

But when i tried to findout AuthenticationToken by id then it is not working.

@Query("{'user._id' : ?0}")
        AuthenticationToken findByUserId(String userId);

My data in authentication table is as following:

> db.authenticationToken.find().pretty()
{
    "_id" : ObjectId("5565b4d444ae3b1a9228be87"),
    "_class" : "com.samepinch.domain.user.AuthenticationToken",
    "token" : "545c1d10-d769-41cf-a47c-2d698ec4df72",
    "user" : {
        "_id" : ObjectId("5565b4d444ae3b1a9228be86"),
        "age" : 0,
        "username" : "[email protected]",
        "firstName" : "Dinesh Dhiman",
        "email" : "[email protected]",
        "gender" : "male",
        "createdDate" : ISODate("2015-05-27T12:13:08.562Z"),
        "updatedDate" : ISODate("2015-05-27T12:13:08.562Z")
    },
    "createdDate" : ISODate("2015-05-27T12:13:08.605Z"),
    "updatedDate" : ISODate("2015-05-27T12:13:26.436Z")
}

I want to fetch data on the basis of userId. Can anyone help me.

there is no userId field in the document

PaulShovan
– PaulShovan

2015-05-27 12:37:37 +00:00
Commented May 27, 2015 at 12:37 — PaulShovan
– PaulShovan, Commented May 27, 2015 at 12:37

user1211 · Accepted Answer · 2015-12-30 12:49:39Z

0

I tried the same example. Try this sample code. It worked for me.

@Query("{user._id:?0}")
AuthenticationToken findByUser(String userId);

answered Dec 30, 2015 at 12:49

user1211

1,5151 gold badge18 silver badges27 bronze badges

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

Comments

Bozic · Accepted Answer · 2017-06-05 12:06:24Z

0

In some versions of Spring you must use ObjectId class instead of String.
So you can try something like this

@Query("{'user._id' : ?0}")
    AuthenticationToken findByUserId(ObjectId objectId);

If you want to use this query in code, it will look something like this

String userId = "someUserId";
repository.findByUserId(new ObjectId(userId));

answered Jun 5, 2017 at 12:06

Bozic

1571 silver badge14 bronze badges

Collectives™ on Stack Overflow

Write custom query in mongodb repository

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related