Java Mongo aggregation or function?

Question

In the Java mongo driver how do you do an or search?

In the mongo aggregation framework it is documented as $or. But when I try and use that as as match criteria it throws an invalid operation exception.

So I tried omitting the operation and using the following, (this is Groovy code but using the Java driver)

def r = getCollection(collectionName).aggregate(
        [$match: [transactionType: [or: [1, 2]]],
        [$group:
                [_id: null,
                        sum: [$sum: '$property']]
        ]
).results()

But that doesn't work either. I've also tried removing the operator entirely and using just a List of values, but that also doesn't work.

I've tried looking throw the Java Mongo driver documentation but haven't found any mention of this. Anyone know the correct way to do an or operation here?

James McMahon · Accepted Answer · 2013-07-08 17:39:39Z

2

I think the problem is the way you're constructing your "or" statement. Does the following work instead?

[$match: [$or: [transactionType: 1],
               [transactionType: 2]]],
[$group .....

edited Jul 8, 2013 at 17:39

James McMahon

49.9k69 gold badges212 silver badges288 bronze badges

answered Jul 7, 2013 at 8:44

Trisha

3,9511 gold badge28 silver badges40 bronze badges

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

1 Comment

James McMahon Over a year ago

That works, with a minor change to make the $match object a map. Thanks.

Collectives™ on Stack Overflow

Java Mongo aggregation or function?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related