Mongo Shell Query in Java

Question

Is there any easy way of firing Mongo query in Java??

db.Test.aggregate(
    [
    {
        '$match':
        {
        'o': { '$gt': [] }
        }
    },
    {
        '$project': {
        'uid': 1,
        'o': 1
        }
    },
    {
        '$project': {
        '_id': 0,
        'uid': 1,
        o: {
            $filter: {
            input: "$o",
            as: "item",
            cond: {
                $and: [
                {
                    $lt: [ "$$item.ad", 0 ]
                },
                {
                    $lt: [ "$$item.at", 0 ]
                }
                ]
            }
            }
        }
        }
    },
    {
        '$match': {
        'o': { '$gt': []}
        }
    },
    {
        $project: {
        uid: 1,
        "mids": "$o.mid"
        }
    },
    {
        $unwind: "$mids"
    },
    {
        $group: {
        _id: {
            uid: "$uid",
            mid: "$mids"
        },
        count: { $sum: 1 }
        }
    },
    {
        $project: {
        _id: 0,
        uid: "$_id.uid",
        mid: "$_id.mid",
        count: 1
        }
    }
    ]
);

Is http://jongo.org serve the purpose for complex queries?

I did not know jongo until now but it seems to make the querying in java a lot more palatable by using the JSON style query language. — Alex Perrin
– Alex Perrin, Commented Nov 27, 2017 at 20:45

kevinadi · Accepted Answer · 2017-11-28 01:34:33Z

1

As an alternative, you can use the Java driver's Document.parse() method. You can supply a JSON string to the method (following MongoDB's extended JSON formatting), and it will return a parsed BSON document for you.

Please see http://mongodb.github.io/mongo-java-driver/3.5/javadoc/org/bson/Document.html#parse-java.lang.String- for the method's documentation.

answered Nov 28, 2017 at 1:34

kevinadi

13.9k3 gold badges38 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Mongo Shell Query in 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