Home query at postgres HOW in Spring JPA
Reply: 0

query at postgres HOW in Spring JPA

user470
1#
user470 Published in May 23, 2018, 8:09 pm

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...

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.337678 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO