Extra quotes being added to @Query

Question

I have the following JSON structure:

{
  "communication": {
      "office": {
        "email": "[email protected]"
      },
      "private": {
        "email": "[email protected]"
      },
  }
}

I want to query dynamically for the email based on the type e.g. office or private. When I use the following command:

@Query(value = "{ 'communication.?0.email' : ?1 }")
Object findByEmail(String type, String email);

The

'communication.?0.email'

is converted to

'communication."office".email'

and mongo didn't find an entry. How can I avoid the quotes before and after office?

Answer 1

Simple answer is spring mongo doesn't supports what you are looking for. Why you are not passing everything as parameter rather as below.

@Query(value = "{ 'communication.?0.email' : ?1 }") Object findByEmail(String type, String email);

where email value should

type= "communication." + type + ".email"