modicio/modic.io.repository/InstanceRepository/getInstancesByTypeNameSoftMatchAndVariant

getInstancesByTypeNameSoftMatchAndVariant

@Query(value = "SELECT f.dataid from Fragment f LEFT JOIN instance i on i.dataid = f.instance_dataid WHERE i.model_root like :type_uri_pattern AND f.variantid = :variantID limit :limit", nativeQuery = true)
abstract fun getInstancesByTypeNameSoftMatchAndVariant(@Param(value = "type_uri_pattern") typeURIPattern: String, @Param(value = "variantID") variantID: String, @Param(value = "limit") limit: Int): List<Long>