count
@Query(value = "SELECT COUNT(m) FROM Message m WHERE m.contactId = :contactId AND m.direction = 'INBOUND' AND m.status != 'READ'"
count
abstract fun countUnreadByContactId(contactId: String): Long(source)