get
Devices
@Query(value = ""SELECT DISTINCT new com.tecknobit.glider.services.users.dtos.DeviceLastLogin(" +
"d," +
"ud." + "lastLogin" +
") FROM com.tecknobit.glider.services.users.entities.ConnectedDevice d" +
" INNER JOIN com.tecknobit.glider.services.users.entities.DeviceUserSession ud" +
" ON d." + IDENTIFIER_KEY + "=" + "ud.device." + IDENTIFIER_KEY +
" WHERE ud.user." + IDENTIFIER_KEY + "=:" + USER_IDENTIFIER_KEY"
)
Query used to retrieve all the devices owned by the user
Return
the devices owned by the user as List of DeviceLastLogin
Parameters
userId
The identifier of the user
pageable
The parameters to paginate the query