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.

Using Join in query

Discussion in 'Developing, APIs and extending' started by zeeshu96, Jun 20, 2016.

  1. zeeshu96

    zeeshu96 New Member


    I am new to kayako.
    I want to retrieve data from two tables, so I have an option to use join but It is not working.

    $this->UserInterfaceGrid->SetQuery('SELECT * FROM ' . TABLE_PREFIX . 'assets a JOIN '.TABLE_PREFIX.'assetgroups ag on(a.groupid=ag.assetgroupid)',
    'SELECT COUNT(*) AS totalitems FROM ' . TABLE_PREFIX . 'assets');

    Kindly Guide me...

Share This Page