1. Kayako Download customers: we will continue to develop and support Kayako Download beyond July 2017, alongside the new Kayako for existing customers.

    Find out more.

  2. The forum you are viewing relates to Kayako Classic. If you signed up or upgraded to the new Kayako (after the 4th July 2016), the information in this thread may not apply to you. You can visit the forums for the new Kayako here.

KSQL Edit - Ticket assignment

Discussion in 'Kayako reports (Kayako Classic)' started by Christoper Alvarez, Oct 12, 2018.

  1. Christoper Alvarez

    Christoper Alvarez New Member

    I am trying to figure out how to show only one specific Staff or department that change the ticket assignment. Below in ?????????? is where I am faulting to produce data.


    SELECT DISTINCT 'Ticket Audit Logs.Creation Date', 'Tickets.Ticket ID', CUSTOMFIELD('Tickets', 'Classification'), 'Tickets.Owner', 'Tickets.User', 'Tickets.Subject', 'Ticket Audit Logs.Message' FROM 'Ticket Audit Logs' where 'Ticket Audit Logs.message' like 'Ticket owner changed from: -- Unassigned -- to:%' and 'Ticket owner changed by: ?????????? to:%' and 'Ticket Audit Logs.Creation Date' > mktime(0,0,0,9,1,2018) AND 'Ticket Audit Logs.Creation Date' < mktime (23,59,59,10,1,2018)
     

Share This Page