Spring Data optional parameter in query method

by

I don’t believe you’ll be able to do that with the method name approach to query definition. From the documentation (reference):

Although getting a query derived from the method name is quite
convenient, one might face the situation in which either the method
name parser does not support the keyword one wants to use or the method
name would get unnecessarily ugly. So you can either use JPA named
queries through a naming convention (see Using JPA NamedQueries for
more information) or rather annotate your query method with @Query

I think you have that situation here, so the answer below uses the @Query annotation approach, which is almost as convenient as the method name approach (reference). 

    @Query("select foo from Foo foo where foo.bar = :bar and "
        + "(:goo is null or foo.goo = :goo)")
    public List<Foo> findByBarAndOptionalGoo(
        @Param("bar") Bar bar, 
        @Param("goo") Goo goo);

More Related Contents:

  1. Disable all Database related auto configuration in Spring Boot
  2. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  3. Spring Data and Native Query with pagination
  4. Spring Data JPA map the native query result to Non-Entity POJO
  5. Joining two table entities in Spring Data JPA
  6. Spring data JPA query with parameter properties
  7. How to test Spring’s declarative caching support on Spring Data repositories?
  8. Spring Data JPA – Multiple EnableJpaRepositories
  9. Spring Data: “delete by” is supported?
  10. Can Spring Data REST’s QueryDSL integration be used to perform more complex queries?
  11. How to use OrderBy with findAll in Spring Data
  12. Can’t Autowire @Repository annotated interface in Spring Boot
  13. Spring @Transactional with a transaction across multiple data sources
  14. Spring Boot – Loading Initial Data
  15. Using generics in Spring Data JPA repositories
  16. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  17. How to use Spring managed Hibernate interceptors in Spring Boot?
  18. Hibernate configuring multiple datasources and multiple session factories
  19. Java SE + Spring Data + Hibernate
  20. Spring Data JPA – Pass column name and value as parameters
  21. No property found for type… custom Spring Data repository
  22. How to use @Transactional with Spring Data?
  23. How to map sql native query result into DTO in spring jpa repository?
  24. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  25. Spring Data JPA: Query by Example?
  26. Configure Multiple MongoDB repositories with Spring Data Mongo
  27. Spring Data JPA find by embedded object property
  28. Spring Data + JPA with multiple datasources but only one set of Repositories
  29. With Spring Data REST, why is the @Version property becoming an ETag and not included in the representation?
  30. How to apply Spring Data projections in a Spring MVC controllers?

Leave a Comment