Hello everyone,
I am working on a help desk report. I have created a Ticket Custom field under Helpdesk settings - Ticket Content - Ticket Custom fields.
The Name (label) is "Confidential", the Type is "Yes/No" box with Used "Yes".
I would like for a column to come up in this report that would show if an agent had selected "Yes" to the "Confidental" box in a Column called "Confidential?"
I've tried linking the various htblcustomfields tables but it seems to break the report (for some reason showing WAY more tickets than for the date range select).
Currently, the report as is looks like this
Select Top 1000000 htblusers.department As Department,
htblticket.ticketid As [Ticket ID],
htblticket.date As [Date Created],
htblusers1.name As Agent,
htblusers.name As Requester,
htblticket.subject As Subject,
htblnotes.note As Description
From htblticket
Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Left Join htblagents On htblagents.agentid = htblticket.agentid
Left Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Where htblticket.date Between Cast('11-05-2017' As Date) And Cast('11-09-2017'
As Date) And htblticketstates.statename = 'Closed'
Order By Department,
[Ticket ID],
[Date Created]
I would absolutely appreciate any help or if someone can just nudge me in the right direction.
Thank you for taking the time to read this.
