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.

getting errors on KQL report

Discussion in 'Kayako reports (Kayako Classic)' started by Alexi Georghiou, Oct 10, 2017.

  1. Alexi Georghiou

    Alexi Georghiou New Member

    If I add 'User Emails.Email' to the SELECT fields and 'User Emails' to FROM it breaks the below report.
    How can I add user email to the report

    SELECT 'Users.User Organization', 'Users.Full Name', 'Tag Links.Tag', 'User Organizations.Creation Date', 'Users.Expiry', 'User Emails.Email'
    FROM 'Users', 'User Organizations', 'Tag Links'
    ORDER BY 'Tag Links.Tag Link ID' DESC
     
  2. Gurpreet Singh

    Gurpreet Singh Staff Member

    Hello there!

    Kindly use the KQL query given below and it work for you:

    SELECT SUM('Ticket Billing.Time Spent'), SUM('Ticket Billing.Time Billable') FROM 'Ticket Billing', 'Tickets', 'Users' WHERE 'Ticket Billing.Creation Date'>= '2015-06-19' AND 'Ticket Billing.Creation Date' <= '2015-05-19'AND 'Ticket Billing.Worker' = 'Support' GROUP BY 'Ticket Billing.Creation Date':DayName ORDER BY 'Ticket Billing.Creation Date'

    The faulty part in your KQL is: WHERE 'Ticket Billing.Creation Date' created &gt;= '2015-06-19' AND created &lt;= '2015-05-19'

    There is no such variable called created in KQL and hence you are getting the mentioned error.

    Please give it a try and let me know how it goes.

    Kind regards,
     

Share This Page