private Set<String> areas=new HashSet<>();
@ElementCollection
@OrderColumn(name = "manager_id")
public Set<String> getAreas() {
return areas;
}
public void setAreas(Set<String> areas) {
this.areas = areas;
}
@ElementCollection(fetch = FetchType.EAGER, targetClass = java.lang.String.class)
@CollectionTable(name = "service_tags", joinColumns = @JoinColumn(name = "s_id"))
@Column(name = "tag")
private Set<String> tags;
"select s from Service s where s.status=0 and (s.serviceType=9 or 'College' in elements(s.tags))"