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.

KQL - 2 tags requirement

Discussion in 'Kayako reports (Kayako Classic)' started by G.Kourtoglou, Mar 27, 2019.

  1. G.Kourtoglou

    G.Kourtoglou New Member

    Hello everyone, KQL and SQL noob here. :)

    I'm trying to create a report based on tickets that have 2 specific tags.

    I have created the below but it doesn't work.

    SELECT 'Tickets.Ticket ID', 'Tickets.Creation Date', 'Tickets.Owner'
    FROM 'Tickets', 'Tag Links'
    WHERE 'Tag Links.Tag' IN ('wisdom','support')
    ORDER BY 'Tickets.Creation Date'
    MULTIGROUP BY 'Tag Links.Tag' Totalize by Count(*)

    I want the report to contain the tickets that have both tags. If a ticket has only one of the above tags then the condition is not met.

    Reason
    We send support requests to various contractors. On the above example, I want to monitor the number of requests made to the contractor "wisdom".

    Thanks in advance,
    George Kourtoglou
     

Share This Page