innoqueue/com.innopolis.innoqueue.domain.notification.dao/NotificationRepository/findAllByToken

findAllByToken

@Query(value = " SELECT * FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) ", countQuery = " SELECT count(*) FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token); ", nativeQuery = true)
abstract fun findAllByToken(token: String, pageable: Pageable): Page<Notification>

Returns all notification for a particular user token with pagination

Parameters

token

  • user token

@Query(value = " SELECT * FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) order by "date" DESC; ", nativeQuery = true)
abstract fun findAllByToken(token: String): List<Notification>

Returns all notification for a particular user token

Parameters

token

  • user token