Find multiple MongoDB records with different combination of values using Spring Data MongoDB criteria

Question

I have a collection with first name, last name and birth year.

[
    {
        "firstName": "John",
        "lastName": "Smith",
        "birthYear": 1990
    },
    {
        "firstName": "Jane",
        "lastName": "Smith",
        "birthYear": 1989
    },
    {
        "firstName": "John",
        "lastName": "Doe",
        "birthYear": 1990
    },
    {
        "firstName": "Jane",
        "lastName": "Doe",
        "birthYear": 1990
    }
]

And I trying to find records with birthYear=1990 and ((firstName=John AND lastName=Smith) or (firstName=Jane AND lastName=Doe)).

The result I want is the following

[
    {
        "firstName": "John",
        "lastName": "Smith",
        "birthYear": 1990
    },
    {
        "firstName": "Jane",
        "lastName": "Doe",
        "birthYear": 1990
    }
]

Is there a way to do this using spring-data-mongodb's Query and Criteria?

varman · Accepted Answer · 2022-06-22 09:15:30Z

0

You may use Criteria query like

Query qa =
  Query.query(
      new Criteria()
          .orOperator(
              Criteria.where("firstName").is("John").and("lastName").is("Smith").and("birthYear").is(1990),
              Criteria.where("firstName").is("Jane").and("lastName").is("Doe")));

or you can write two jpa methods like findAllByFirstNameAndLastNameAndBirthYear(String firstName, String lastName, int birthYear) and findAllByFirstNameAndLastName(String firstName, String lastName) and combine both list together.

answered Jun 22, 2022 at 9:15

varman

8,9306 gold badges25 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Find multiple MongoDB records with different combination of values using Spring Data MongoDB criteria

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