Untitled

 avatar
unknown
plain_text
6 months ago
780 B
5
Indexable
interface ApplicationJpaRepository : JpaRepository<ApplicationEntity, String> {

    @Query(
        "SELECT u FROM Application u WHERE (:isEnabled IS NULL OR u.isEnabled = :isEnabled) " +
            "AND (:name IS NULL OR u.name LIKE %:name%) ORDER BY u.regDate DESC"
    )
    fun finApplications(
        @Param("isEnabled") isEnabled: Boolean?,
        @Param("name") name: String?,
        pageable: Pageable
    ): Page<ApplicationEntity>

    @Query(
        "SELECT count(a) FROM Application a WHERE (:isEnabled IS NULL OR a.isEnabled = " +
            ":isEnabled) AND a.name LIKE %:name% ORDER BY a.regDate DESC"
    ) fun countApplicationsByKeyWord(
        @Param("isEnabled") isEnabled: Boolean?,
        @Param("name") name: String?
    ): Long
}
Editor is loading...
Leave a Comment