mark All As Read By Tenant And User
@Modifying
@Query(value = "
UPDATE Notification n
SET n.read = true
WHERE n.tenantId = :tenantId
AND (n.userId IS NULL OR n.userId = :userId)
AND n.read = false
" )