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
     

Share This Page