Query Elasticsearch using Spring Data Elasticsearch with fields containing underscore

Question

Below is my User model

@Document(indexName="users",type="records")
public class User{
    private String id;
    private String first_name;
    private String last_name;
}

and below is my Repository

@Repository
public interface UserSearchRepository extends ElasticsearchRepository<User,String> {

    public List<User> findAllByFirst_name(String first_name);

}

The above method gives an error of

No property first found for type User

So I want to know how can I query using fieldnames containing underscores

Answer 1

@JsonProperty("first_name")
private String firstName;

In @Query you can use first_name as described here.