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.

swuserprofiles and swcustomfields

Discussion in 'Developing, APIs and extending' started by Håkon Sørensen, May 10, 2016.

  1. Hi all,

    I'm running a query against the Kayako database, and what i would like to do is retriving data stored in custom fields on user profile.

    But what i'm not seeing is the relationship between a users profile. i.e userid 81 and the data stored in his/hers customs fields.

    How does the database link stored data on custom fields up against a user profile ?

    TL;DR: I want to be able to do "select * from swcustomfieldsvalue where userid = 81;" (i know this won't work, but it's what i'm trying to do)

    Thanks!
     
  2. Gary McGrath

    Gary McGrath Staff Member

    Hi there,

    userid = typeid

    Gary
     
  3. Thanks once again Gary!
     

Share This Page