getPotentialMembers

@Query(value = ""SELECT " + IDENTIFIER_KEY + "," + PROFILE_PIC_KEY + "," + NAME_KEY + "," + SURNAME_KEY + "," + EMAIL_KEY + "," + ROLE_KEY + " FROM " + USERS_KEY + " WHERE " + IDENTIFIER_KEY + "!=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun getPotentialMembers(@Param(value = "id") userId: String): List<List<String>>

Method to execute the query to get the potential members for a team

Return

list of potential members as List of List of String

Parameters

userId

: the identifier of the user to not fetch