Hello friends, may anybody help me about custom Query using JpaRepository ? I do use this query:

@Query("select id, email from User")
fun getAllIdsAndEmails(): List<Pair<Long, String>>

But sadly I get an error of

No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [kotlin.Pair<?, ?>]

Have you tried

List<User>

?

let me do it

Have you tried something like this, using some list implementation:

fun getAllIdsAndEmails(): List<Long, String>

? Or, you could use something like they show here: https://faun.pub/select-specific-columns-from-a-database-table-using-spring-data-jpa-d4eb0a24a2c4 That it is similar to what I see in a Stack overflow thread Thats looks like the right path I think

Yes this did not work

I am not sure how to convert to a

Pair

but you can try this interface:

interface UserData {
    val id: Long 
    val email: String?        
}

and then you will have

fun getAllIdsAndEmails(): List<UserData>

Ah yeah, that worked