Untitled
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