0

here is my sql :

SELECT * FROM files F WHERE F.id in ('1','2','3')

Please help me with jpql expression for in function.

prilia
  • 996
  • 5
  • 18
  • 41

1 Answers1

0

It was simple ! :)
SELECT F FROM files F WHERE id in :ids

prilia
  • 996
  • 5
  • 18
  • 41
  • check this example : http://stackoverflow.com/questions/2772305/jpql-in-clause-java-arrays-or-lists-sets – prilia Jun 05 '14 at 11:38
  • and this one !http://stackoverflow.com/questions/19886903/generation-query-when-the-manytomany-relationship-is-used-by-spring-data-jpa-pro – prilia Jun 05 '14 at 11:49