How to read nested array from MonogDB using Java

Question

I need to find the record/count where eventDetails.eventDelivery.stateCode = "Y-FINISH". It could be in any element in the array list.

Just want to find where stateCode = "Y-FINISH" present in the array list.

Sample Data #1:
{
    "_id" : ObjectId("5a2fb09736cf07f6a1146691"),
    "activityID" : "",
    "eventDetails" : [ 
        {
            "eventDelivery" : {
            "digital" : {
                "secureid" : "1231321212"
            },
            "stateCode" : "X-FINISH",
            "state" : "SUCCESS"
        }, 
        {
            "eventDelivery" : {
            "digital" : {
                "secureid" : "8762871121"
            },
            "stateCode" : "Y-FINISH",
            "state" : "SUCCESS"            
        }
    ],
}

Sample Data #2:
    {
        "_id" : ObjectId("5a2fb09736cf07f6a1146691"),
        "activityID" : "",
        "eventDetails" : [ 
            {
                "eventDelivery" : {
                "digital" : {
                    "secureid" : "1231321212"
                },
                "stateCode" : "X-FINISH",
                "state" : "SUCCESS"
            }, 
            {
                "eventDelivery" : {
                "digital" : {
                    "secureid" : "8762871121"
                },
                "stateCode" : "Y-FINISH",
                "state" : "SUCCESS"            
            }, 
            {
                "eventDelivery" : {
                "digital" : {
                    "secureid" : "7651327152
                },
                "stateCode" : "Z-FINISH",
                "state" : "SUCCESS"            
            }
        ],
    }

Need to read this using Java.

glytching · Accepted Answer · 2017-12-12 14:35:43Z

1

Using a 3.x version of the Mongo Java driver ...

MongoClient mongoClient = ...;

MongoCollection<Document> collection = mongoClient.getDatabase("...")
    .getCollection("...");

Bson filter = Filters.eq("eventDetails.stateCode", "Y-FINISH");

long count = collection.count(filter);

answered Dec 12, 2017 at 14:35

glytching

48.5k11 gold badges127 silver badges129 bronze badges

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

Collectives™ on Stack Overflow

How to read nested array from MonogDB using Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related