Spring Boot: keywords supported for JPA

Question

I wanted to perform the Spring JPA repository where wanted to apply the and operation among 2 columns where one column cloud have multiple values in it.

SQL query for the same:

select * from table_name where col1='col1_val' and col2 IN ('col2_val_a','col2_val_b','col2_val_c');

I know that for and operation I can extend the JpaRepository and create the method with like this for:

List<MyPoJoObject> findByCol1AndCol2(String col1_val,String col2_val);

and for IN operation we can use : findByCol2In(Collection<String> col2_val)

But i did not know how i can club both the mentioned JPA default method into one, as per my sql statement mentioned before.

Answer 1

You can use the following method named:

List<MyPoJoObject> findByCol1AndCol2In(String col1_val, Collection<String> col2_val);

On this link repository-query-keywords you can find repository query keywords that you can use and combine them as well.

Answer 2

You can certainly combined both into one method.

List<MyPoJoObject> findByCol1AndCol2In(String col1_val,String[] col2_val);

Try this. I am not sure if it will accept Collection<String>. I will try that and update the answer.

HTH.

Answer 3

If you want to perform this logic for more than two columns then your method name becomes verbose.

Instead of stuck with Spring naming why can't you write your own JPA query.

Example:

@Query("select pojo from MyPoJoObject as pojo where pojo.col1 = :col1_val and pojo.col2 in :col2_val")
List<MyPoJoObject> findByColumns(String col1_val, List<String> col2_val);