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.

Assistance with Query

Discussion in 'Kayako reports (Kayako Classic)' started by jnowak, Jul 27, 2016.

  1. jnowak

    jnowak New Member

    I am trying to set up a query to pull based off of information in a certain field of the post contents.
    There is a content section in my view called: Sales Rep. It looks like this:

    Sales Rep: NAME

    The query I use is:
    SELECT 'Tickets.Ticket ID', 'Tickets.Subject', 'Tickets.User', 'Ticket Posts.Contents' from 'Ticket Posts' where 'Ticket Posts.Contents' LIKE '%Sales Rep: NAME'
    However it keeps telling me that there is no information. I have used different users as well, in case someone did get removed from the system, but get the same output. Thoughts please.

Share This Page