modicio/modic.io.repository/FragmentRepository/findMostRecentFragmentsByVariantTimeLazy

findMostRecentFragmentsByVariantTimeLazy

@Query(value = "SELECT * from Fragment f WHERE f.variant_time = :variantTime AND running_time = ( SELECT MAX(running_time) FROM Fragment f1 WHERE f1.variant_time = :variantTime) AND f.open = :isOpen ORDER BY running_time DESC LIMIT :limit", nativeQuery = true)
abstract fun findMostRecentFragmentsByVariantTimeLazy(@Param(value = "variantTime") variantTime: Timestamp, @Param(value = "limit") limit: Int, @Param(value = "isOpen") isOpen: Boolean = false): List<Fragment>