Hi there,
I am currently in the process of creating an evaluation for our tickets. Unfortunately, I have a little problem with that. I can't find the right group for the type.
I can only find the ID and not the full name.
I mean this type here:
here my previous code:
Select Top 1000000 htblticket.ticketid As [Ticket ID],
htblticket.subject As Betreff,
htblticket.date As Datum,
htblusers.name As [Erstellt von],
htblusers.company As Firma,
htblticketstates.statename As Status,
htblusers1.name As Agent,
htblpriorities.name As Priorität,
htblteams.teamname As Team
From htblticket
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Inner Join lansweeperdb.dbo.htblpriorities On htblticket.priority =
htblpriorities.priority
Inner Join lansweeperdb.dbo.htblticketteam On htblticket.ticketid =
htblticketteam.ticketid
Inner Join lansweeperdb.dbo.htblteams On htblticketteam.teamid =
htblteams.teamid
Order By [Ticket ID]
Thank you in advance and have a nice time before Christmas!
Sincerely, Fabio
