JPA: check if one array overlaps another/do arrays have common items
My tech stack is Kotlin/Spring Data JPA/Hibernate/Postgres. I implement PagingAndSortingRepository interface to initialize all logic I need to manage entities.
Let's consider I have an entity class:
@Entity
@Table(name = "team")
@TypeDefs(
TypeDef(name = "jsonb", typeClass = JsonBinaryType::class),
TypeDef(name = "list-array", typeClass = ListArrayType::class)
)
data class TeamEntity(
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
var id: Long? = null,...