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.

Create report where it lists the tickets from users that have a chat today

Discussion in 'Technical chat' started by Leos, Jul 14, 2017.

  1. Leos

    Leos New Member

    Please help.
    I need to create report where it lists the open tickets from users that connected to chat on the same day.
    I tried it on my end--using the most basic KQL knowledge that I have--but can't seem to figure out.

    SELECT 'Tickets.Ticket Mask ID' FROM 'Tickets', 'Chats' WHERE 'Chats.Email' = 'Tickets.Email' AND 'Tickets.Creation Date' = Today()

    The above says it's tickets is not related to chatobjects when I ran it.

    Please advise.

Share This Page