osTicket: How to Query a Ticket Subject for a Report

[scottalanmiller]

osTicket can be a little obtuse. The title of a ticket is hidden in the ticket__cdata table, which by default is ost_ticket__cdata in the subject column.

Take a quick peek and you will see it.

SELECT * FROM ost_ticket__cdata LIMIT 4;

Now, knowing what it is called and where to find it, you can use ost_ticket__cdata in your queries. Notice that there are two underscores together in that table name.