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

# spring

[Okan Yıldırım]

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<?, ?>]

[Okan Yıldırım]

Also tried List<Tuple>, still did not work

[Okan Yıldırım]

But the return type is like Pair

this is example return
[ [ 0, “[e-mail]” ], [ 1, “[e-mail]” ] ]

[Gabriel Pomin]

Have you tried List<User> ?

[Okan Yıldırım]

let me do it

[Okan Yıldırım]

but I am not selecting all required fields of user

[Okan Yıldırım]

Yeah it gave error

[Gabriel Pomin]

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

[Okan Yıldırım]

Yes this did not work

[Pavel]

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>

[Okan Yıldırım]

Ah yeah, that worked

[Okan Yıldırım]

Thanks