modicio/modic.io.repository/FragmentRepository/findMostRecentFragmentsByVariantNameLazy

findMostRecentFragmentsByVariantNameLazy

@Query(value = "SELECT DISTINCT ON (running_time, variantID) f.* from Fragment f WHERE f.variant_name = :variantName AND running_time = ( SELECT MAX(running_time) FROM Fragment f1 WHERE f1.variant_name = :variantName) AND f.open = :isOpen ORDER BY running_time DESC, variantID LIMIT :limit", nativeQuery = true)
abstract fun findMostRecentFragmentsByVariantNameLazy(@Param(value = "variantName") variantName: String, @Param(value = "limit") limit: Int, @Param(value = "isOpen") isOpen: Boolean = false): List<Fragment>