Esben.D wrote:
The report below should get you started. I've added all the tables you needed, all you need to do is just enable the fields you want to see and add conditions. That can all be done in the visual interface.
Select Top 1000000 htblticket.subject
From htblcustomfields
Inner Join htblcustomfieldvalues On htblcustomfields.fieldid =
htblcustomfieldvalues.fieldid
Inner Join htblticketcustomfield On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Inner Join htblticket On htblticket.ticketid = htblticketcustomfield.ticketid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Hi Esben,
Thank you, I have tried adding in a filter to show anything with Other and add in the ticket ID but the filter does not work and just adds a column with other next to everything and the ID does not show. Blow is the new SQL Code
Select Top 1000000 htblticket.subject,
htblcustomfieldvalues.value,
htblticket.ticketid
From htblcustomfields
Inner Join htblcustomfieldvalues On htblcustomfields.fieldid =
htblcustomfieldvalues.fieldid
Inner Join htblticketcustomfield On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Inner Join htblticket On htblticket.ticketid = htblticketcustomfield.ticketid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Where htblcustomfieldvalues.value = 'Other'
Group By htblticket.subject,
htblcustomfieldvalues.value,
htblticket.ticketid