modicio/modic.io.repository/FragmentRepository/findAllRunningVersionsOfVariant

findAllRunningVersionsOfVariant

@Query(value = "SELECT DISTINCT ON (runningid) * from Fragment WHERE variantid = :variantID AND open = :isOpen ORDER BY runningid DESC LIMIT :limit", nativeQuery = true)
abstract fun findAllRunningVersionsOfVariant(@Param(value = "variantID") variantID: String, @Param(value = "limit") limit: Int, @Param(value = "isOpen") isOpen: Boolean = false): List<Fragment>