Using an object instead of single parameters in JPA/JPQL @Param @Query

Question

When doing querys you can do this syntax:

@Query(value = "SELECT v from DBTABLE v WHERE v.param1 = param1 AND v.param2 = param2")
List<Result> search(@Param("param1") String param1, @Param("param2") String param2)

What if I had more then 2 parameters. Lets say I had 20 parameters, is there a way to give an object instead and refer to the object properties instead? What I mean is this:

Pseudocode:

@Query(value = "SELECT v from DBTABLE v WHERE v.param1 = object.param1 AND v.param2 = object.param2")
List<Result> search(@Param("Object") SomeCustomObject object)

I see, I thought it would be implied, but I found that is quite similar to what you are looking for. Does this work for you? stackoverflow.com/a/28993810/16034206 — pebble unit
– pebble unit, Commented Jul 27, 2023 at 8:59
That's the exact thing I was looking for, thank you. You can post an answer and I'll accept it. — sander
– sander, Commented Jul 27, 2023 at 11:24

pebble unit · Accepted Answer · 2023-07-27 12:38:37Z

5

Spring Data JPA has SpEL support that provides access to the query method arguments. This allows you to either simply bind the parameter as is or perform additional operations before binding.

This lets you write queries such as:

@Query("select u from User u where u.age = ?#{[0]}")
List<User> findUsersByAge(int age);

@Query("select u from User u where u.firstname = :#{#customer.firstname}")
List<User> findUsersByCustomersFirstname(@Param("customer") Customer customer);

For more details, see also

answered Jul 27, 2023 at 12:38

pebble unit

1,4314 gold badges11 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Using an object instead of single parameters in JPA/JPQL @Param @Query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related