cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
INNO-IT
Engaged Sweeper II
Hi,

Is there a possibility to print all tickets assigned to an agent.
1 REPLY 1
Karel_DS
Champion Sweeper III
There isn't an instant solution for this. But if all you need is things like ticket ID and subject then you could create a custom report:

select ticketid, subject from htblticket INNER JOIN
htblagents ON htblagents.agentid = htblticket.agentid INNER JOIN
htblusers ON htblusers.userid = htblagents.userid
WHERE htblusers.name = 'Built-in admin'


To also get the initial description, use this query:
select htblticket.ticketid, htblticket.subject, htblnotes.note AS description from htblticket INNER JOIN 
htblagents ON htblagents.agentid = htblticket.agentid INNER JOIN
htblusers ON htblusers.userid = htblagents.userid
INNER JOIN htblnotes on htblnotes.ticketid = htblticket.ticketid
WHERE htblusers.name = 'Built-in admin' AND htblnotes.notetype = 3