any Unread Notification
@Query(value = "
SELECT EXISTS(
SELECT *
FROM notification
WHERE user_id = (SELECT user_id
FROM "user"
WHERE token = :token)
AND is_read = false
);
", nativeQuery = true )
Returns boolean whether there is any unread notification for a particular user token
Parameters
token
user token