I am trying this ```data class InvitationListItem(...
# spring
d
I am trying this
Copy code
data class InvitationListItem(
    var created: Date = Date(),
    var role: DealRole = DealRole.Seller,
    var email: String = "",
    var phone: String = "",
    var inviteeId: Long? = null,
    var inviteeName: String = ""
) : Serializable
Copy code
interface InvitationRepository : JpaRepository<Invitation, UUID> {
    @Query("""
select
  invitations.created,
  invitations.role,
  invitations.email,
  invitations.phone,
  invitations.invitee_id,
  users.name as inviteeName
from invitations
  left join users
    on users.id = invitations.invitee_id
where invitations.status != 'Declined'
  and invitations.deal_id = ?1""", nativeQuery = true)
    fun getDealInvitations(dealId: Long): List<InvitationListItem>
}