Nested fields query by using mongo repository in java

Question

i want to get the value of Id by using mongorepository. Below example shows mondodb document

{
    "_id" : ObjectId("5baa4779f4a46b0f60a74313"),
    "_class" : "hello.mytest",
    "data" : {
        "type" : [ 
            {
                "testId" : "Id0",
                "usage" : "near",
                "additionalProperties" : {}
            }, 
            {
                "testId" : "Id1",
                "usage" : "far",
                "additionalProperties" : {}
            }]}
            }

when i try to find testId getting null value.

public interface TestRepository extends MongoRepository<mytest, String> {
        List<data> findBytestId(String string);
            }

matthPen · Accepted Answer · 2018-09-26 08:09:05Z

1

Simply add annotation to your method :

public interface TestRepository extends MongoRepository<mytest, String> {
        @Query("{'data.type.testId': ?0}")
        List<data> findBytestId(String string);
}

answered Sep 26, 2018 at 8:09

matthPen

4,3731 gold badge18 silver badges18 bronze badges

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

2 Comments

Sriram Over a year ago

Thanks its working , I have one doubt regarding mongo pojo class of mytest i.e if i set other field name with MsgId in mongo pojo class, when i try to find that value getting no property found on mytest class, if i changed to msgId then i am getting value.what is the reason for this? for example { "MsgId": "not getting value", "data" : { "type" : [ ] }}

matthPen Over a year ago

it probably comes from Spring, which needs bean fields to have particular syntax (minus character as first, camelCase syntax, etc...)

Anjana Thrishakya · Accepted Answer · 2018-09-26 08:08:33Z

0

findBytestId => "testId" must be "TestId"

public interface TestRepository extends MongoRepository<mytest, String> {
    List<data> findByTestId(String testId);
}

answered Sep 26, 2018 at 8:08

Anjana Thrishakya

313 bronze badges

Collectives™ on Stack Overflow

Nested fields query by using mongo repository in java

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related