osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
How to pull via SQL custom form entered data
Folks, I know this is easy, and I am not asking to MOD the distribution.
I have a help topic called travel task, and it uses a custom form called travel form which asks some special questions.
After someone enters all of the data into this travel ticket. I want to simply later run a php/sql query outside of osticket so I can pull all the info that has been gathered.
But I simply don't know in which osticket database table the info will be sitting in.
I want to later simply give a sql query similar to
SELECT field1, field2....etc from table where key is equal to topic id = 17 (I was able to find out that my travel ticket topic has been assigned topic id 17)
I have attached some screen shots of the version number, as well as the ticket custom form that defines the fields/columns of the entries that I assume are being placed in the database somewhere....
Similarly, what would be other table and fields that I should query to get the basic ticket info that every ticket collects.
Many thanks everyone.