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.

Customfield Issue

Discussion in 'Kayako reports (Kayako Classic)' started by Placeholder, Dec 6, 2017.

  1. Placeholder

    Placeholder New Member

    Hey all,

    I'm having some issues working with the customfield part of a query.

    The following works perfectly:
    Code:
    SELECT 'Tickets.Ticket ID', 'Tickets.Subject', 'Tickets.Department', 'Tickets.Creation Date', 'Tickets.First Response Time' FROM 'Tickets' WHERE 'Tickets.Department' = 'Hosting and Server Support' AND 'Tickets.Creation Date' >= MKTIME(0,0,0,10,1,2017) AND 'Tickets.Creation Date' <= MKTIME(0,0,0,10,31,2017) AND CUSTOMFIELD('Select a location') = 'Canada' MULTIGROUP BY 'Tickets.owner' ORDERBY 'Tickets.Creation Date'
    The following returns the error "Custom fields not supported for the table at offset 201."
    Code:
    SELECT 'Tickets.Ticket ID', 'Tickets.Subject', 'Tickets.Department', 'Tickets.Creation Date', 'Tickets.First Response Time' FROM 'Tickets' WHERE 'Tickets.Department' = 'Hosting and Server Support' AND CUSTOMFIELD('Select a location') = 'Canada' AND 'Tickets.Creation Date' = ThisWeek() MULTIGROUP BY 'Tickets.owner' ORDERBY 'Tickets.Creation Date'
    For reference, character 201 is the C in CUSTOMFIELD. Any idea what I'm missing?

    Thanks in advance
     

Share This Page