title: Find elements in a collection field Spring Data JPA Query
body: <p>I have an entity contains a collection field</p>
  
  <pre><code>@Entity
  @Table(name = "SERVICE")
      public class Service {
  
  @Id
      @GeneratedValue(strategy = GenerationType.AUTO, generator = "SEQUENCE")
      @SequenceGenerator(name = "SEQUENCE", sequenceName = "SEQUENCE")
      @Column(name = "ID_SERVICE")
      private Integer id;
  
          @ElementCollection
      @CollectionTable(name = "SERVICE_JOB",
              joinColumns = @JoinColumn(name = "ID_SERVICE", referencedColumnName = "ID_SERVICE"))
      @Column(name = "JOB")
      private List&lt;String&gt; jobs = new ArrayList&lt;String&gt;();
      }
  </code></pre>
  
  <p>I want to return services where field jobs contains my variable "job"</p>
  
  <pre><code>@Query("SELECT DISTINCT s FROM Service s WHERE ?1 in (s.jobs)")
  List&lt;Service&gt; findByJob(String job);
  </code></pre>
  
  <p>It always returns an empty list although field jobs contains my variable</p>
  
  <p>Any suggesstions? </p>