Spring data mongoDB push operation with multiple fields are not working

Question

I have a set of data objects in MongoDB as-

[
    { "status" : "passed", "version" : "124" , "value" : 6 },
    { "status" : "passed", "version" : "123" , "value" : 10 },
    { "status" : "failed", "version" : "123" , "value" : 16 }
]

and i want to get it in a format like -

[
    { 
    version: 124,
    "series" :[ 
        { 
            "name" : "passed", 
            "value" : 6 
        }
      ]
    },
    {
    version: 123,
    "series" : [
         { 
             "name" : "passed", 
             "value" : 10 
         },
         { 
             "name" : "failed", 
             "value" : 16 
         }
      ]
    }
]

how should i write the query? I wrote query like

I have written a query like:

Aggregation.group("version").push(new BasicDBObject("name","$status").append("value", "$value")).as("series");

using the aggregate query above, I'm getting like:

[
    { 
    version: 124,
    "series" :[ 
        { 
          "name" : null, 
          "value" : 6 
        }
      ]
    },
    {
    version: 123,
    "series" : [
         { 
           "name" : null, 
           "value" : 10
         },
         { 
           "name" : null, 
           "value" : 16 
         }
      ]
    }
]

It seems that the value of the status is not taken in the object. How can I resolve this?

I am doing the same and it worked well for me. What is the version of Spring-data-mongodb used by you? — Vihar Manchala
– Vihar Manchala, Commented Mar 18, 2019 at 15:26

Neenu Chandran · Accepted Answer · 2019-03-20 12:25:12Z

My Query is like:

db.results.aggregate([{
     {
       "$group": {
             "_id": {
                  "status": "$status",
                  "version": "$version",
              },
             "count": {
                  "$sum": 1
              }
            }
        }, {
            $group: {
                _id: "$_id.version",
                "series": {
                    $push: {
                        "status": "$_id.status",
                        "value": "$count"
                    }
                }
            }
        }
    ]);

So I have to add the aggregation query as:

Aggregation.group("version").push(new BasicDBObject("_id", "$_id.status").append("value", "$value")).as("series");

Ashwanth Madhav · Accepted Answer · 2019-03-18 14:45:41Z

0

I tried with mongo aggregation. Try in the shell. I am not familiarised with spring.

db.getCollection('Test1').aggregate([
{
$group:{
    _id:"$version",
    version:{$first:"$version"},
    series:{
        $push:{
            name:"$status",
            value:"$value"
            }
        }
    }
},
{$project:{_id:0}}
])

edited Mar 18, 2019 at 14:45

answered Mar 18, 2019 at 14:39

Ashwanth Madhav

1,2341 gold badge12 silver badges23 bronze badges

1 Comment

Neenu Chandran Over a year ago

Thanks for your reponse, but I need spring boot mongoDB query.

Collectives™ on Stack Overflow

Spring data mongoDB push operation with multiple fields are not working

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related