iterating through a collection in JPQL
@Entity
public class Article implements Serializable {

   @Basic(optional = false)
   @NotNull
   @Lob
   @Size(min = 1, max = 65535)
   @Column(name = "body", nullable = false, length = 65535)
   private String body;
   @Basic(optional = false)

   @NotNull
   @Size(min = 1, max = 250)
   @Column(name = "title", nullable = false, length = 250)
   private String title;

   @Basic(optional = false)
   @NotNull
   @Size(min = 1, max = 9)
   @Column(name = "status", nullable = false, length = 9)
   private String status;

   @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
   @JoinColumn(name = "articleId", referencedColumnName = "id", nullable = false)
   private List<Tag> tagList;

   // other attributes and methods
}

SELECT DISTINCT a FROM Article a ,IN(a.tagList) tag
            WHERE a.status = :status AND
            (a.title LIKE :pattern OR a.body LIKE :pattern
            OR tag.name LIKE :pattern)

select distinct a from Article a left join a.tagList tag where a.status = :status and
(a.title like :pattern or a.body like :pattern or tag.name like :pattern)

select a from Article a join a.tagList tag where a.status = :status and
    (a.title like :pattern or a.body like :pattern or tag.name like :pattern)