11-29-202108:16 AM - last edited on 12-02-202212:36 PM by Mercedes_O
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!