query at postgres HOW in Spring JPA

Question

there is here such a request:

select *
from Organization t
where (t.inn,t.kpp) IN(('000000','00000'),('1111111','111111'));

How make this Query in Spring Data JPA. I tried like this:

@Query(value =
"SELECT t" +
    " FROM Organization t" +
    " WHERE (t.inn, t.kpp) IN :innKppList")

List findOrganizationsByInnKpp(@Param("innKppList") Map innKppList);

But it does not work...

also , refer to this post stackoverflow.com/a/48540115/493216 — BigGinDaHouse
– BigGinDaHouse, Commented Feb 12, 2018 at 11:00

Stephan · Accepted Answer · 2018-02-15 13:47:01Z

0

If you can split up your map into two lists this will work

@Query("SELECT t FROM Organization t WHERE t.inn IN ?1 AND t.kpp IN ?2")
Set<Organization> findByInnAndKpp(List<String> inn, List<String> kpp);

answered Feb 15, 2018 at 13:47

Stephan

9506 silver badges14 bronze badges

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

1 Answer 1