hallo,
we need a report with an Custom field "System" and its a Combobox and the user can choose the affected system . We want to see all open and closed Tickes, Date, Agent and the selected system.
i tried with the SQL query bur it´s dont work.
Select Top 1000000 htblcustomfields.name,
htblticketcustomfield.data,
htblticket.date,
htblusers1.name As name1,
htblticket.ticketid,
htblticket.priority,
htblusers1.username,
htblticketstates.statename,
htblticket.updated,
htblticketcustomfield.ticketid As ticketid1,
htblticketcustomfield.fieldid
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
Inner Join htblusers htblusers1 On htblusers1.userid = htblticket.fromuserid
And htblusers1.userid = htblagents.userid
Where htblcustomfields.name = 'System' And htblticket.updated > GetDate() - 30
could you please help me?
