modicio/modic.io.repository/InstanceRepository/getInstancesByTypeNameSoftMatchAndVariantAndVersion

getInstancesByTypeNameSoftMatchAndVariantAndVersion

@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 AND f.runningid = :versionID limit :limit", nativeQuery = true)
abstract fun getInstancesByTypeNameSoftMatchAndVariantAndVersion(@Param(value = "type_uri_pattern") typeURIPattern: String, @Param(value = "variantID") variantID: String, @Param(value = "versionID") versionID: String, @Param(value = "limit") limit: Int): List<Long>