Hi, I just made a breakthrough and thought I would share my SQL string in case this helps anyone. I wanted to pull a custom field from osTicket into my website. Below is the SQL which seems to work, replace '123456' with a ticket number you want to look up. Also you would need to replace the field_id from '123' to whatever your custom fields ID is. You can find that out by logging into your mysql db and reading table: ost_form_field and read the "id" field of which ever row is the custom field you created.SELECT ost_form_entry_values.valueFROM  ost_ticketJOIN ost_form_entry ON ost_ticket.ticket_id = ost_form_entry.object_idJOIN ost_form_entry_values ON ost_form_entry.id=ost_form_entry_values.entry_idWHERE ost_ticket.number = '123456' and ost_form_entry_values.field_id = '123';

Write a Reply...