I want to export all ticket fields. I read that it inposible for custom field, but i want to create script for this.
Please, advise me, which tables and columns from osTicket DB i should select for this?
Maybe i can change osTicket php source code for this?
Okay so pretty sure that you would mean all the following:
ntozier couldn't you please advise SQL query for select data from this tables for each ticket?
I tried to visualize diagram of relationship with "MySQL Workbench", but this show nothing relationship.
You image is missing some of the tables, so not really. I have to see the tables to tell you.
ost_users has default_email_id which would e the ost_user__email id field.
ost_ticket has a help_topic which is the topic_id field
ost_ticket has a user_id (I think) which is the ost_user id field.
ost_ticket has a status_id (I think) which is the ost_ticket_status id field.
ntozier full image
You can open this with good quality in a new tab.
This might be helpful for you:
KevinTheJedi Thanks! Very usefull!