findUnreadByTenantAndUser

@Query(value = " SELECT n FROM Notification n WHERE n.tenantId = :tenantId AND (n.userId IS NULL OR n.userId = :userId) AND n.read = false ORDER BY n.createdAt DESC ")
abstract fun findUnreadByTenantAndUser(tenantId: String, userId: String): List<Notification>(source)