java - 在 Spring JPA 中如何在 postgres 查询

Question

这里有这样一个请求:

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

如何在 Spring Data JPA 中创建此查询。我试过这样:

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

列表 findOrganizationsByInnKpp(@Param("innKppList") 映射 innKppList);

但是没用...

Answer 1

如果您可以将您的 map 分成两个列表，这将有效

@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);