Aggregation with multiple criteria

Question

I want to perform aggregation using multiple criteria. The problem is that I don't know how to pass multiple criteria. Do I declare multiple Match operation like below?

MatchOperation matchOperation1 = Aggregation.match(criteria);
MatchOperation matchOperation2 = Aggregation.match(criteria2);

And if yes, then how do I pass them to the aggregation method? I thought that it should be possible to create a MatchOperation that adheres in multiple criteria but I have not found such an example online.

prasad_ · Accepted Answer · 2020-06-12 10:13:08Z

3

Do I declare multiple Match operation like below?

MatchOperation matchOperation1 = Aggregation.match(criteria); 
MatchOperation matchOperation2 = Aggregation.match(criteria2);

The Criteria class has an and method, which allows combining two conditions. For example, consider the three documents:

{ _id: 1, size: 10, color: "blue" }
{ _id: 2, size: 12, color: "red" }
{ _id: 3, size: 8, color: "blue" }

The aggregation match stage is defined as follows:

Aggregation.match(Criteria.where("size").gt(new Integer(8))
                            .and("color").is("blue")
)

This returns the document with _id: 1.

edited Jun 12, 2020 at 10:13

answered Jun 12, 2020 at 10:07

prasad_

14.4k2 gold badges27 silver badges44 bronze badges

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

Comments

Mansi Joshi · Accepted Answer · 2020-07-11 17:45:48Z

You can also use list of criteria in MatchOperation , when you want filter dynamically:

List<Criteria> criterias = new ArrayList<>();
for (String key : mongoRequest.getFilterQuery().keySet()) {
                Criteria ci= new Criteria();
                List<Object> listOfValues=new ArrayList<>();
                for(Object value:mongoRequest.getFilterQuery().get(key)){
                    listOfValues.add(value);
                }
                ci = Criteria.where(key).in(listOfValues);
                criterias.add(ci);
           }
MatchOperation match =new MatchOperation(!criterias.isEmpty()?new Criteria().andOperator(criterias.toArray(new Criteria[criterias.size()])):new Criteria());

you can also refer this link link.

Ameerah Khan · Accepted Answer · 2020-06-12 10:47:59Z

1

You can try something like this

final Criteria firstMatchCriteria = Criteria.where("fielname").is(someValue)
final Criteria secondMatchCriteria = Criteria.where("fielname").is(someValue)
final Aggregation aggregation = Aggregation.newAggregation(        match(firstMatchCriteria),unwind("FIELD_"),match(secondMatchCriteria),project())

answered Jun 12, 2020 at 10:47

Ameerah Khan

806 bronze badges

Comments

Fernando · Accepted Answer · 2021-03-09 22:18:00Z

1

I have a better solution

Criteria result = criteria1.andOperator(criteria2, cri2teria,......)

answered Mar 9, 2021 at 22:18

Fernando

4431 gold badge8 silver badges30 bronze badges

Comments

C96 · Accepted Answer · 2020-06-12 11:00:19Z

0

That worked for me after all.

    Criteria criterias = new Criteria().andOperator(Criteria.where(Force.AMOUNT).gte(minForceAmount)
            .and(ForceType.TYPE).is(ForceTypeEnum.MAGNETIC_FORCE)
            .and("createdAt").gte(startDate).lte(endDate));
    MatchOperation matchOperation = Aggregation.match(criteria);

answered Jun 12, 2020 at 11:00

C96

5292 gold badges12 silver badges40 bronze badges

Collectives™ on Stack Overflow

Aggregation with multiple criteria

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related