- Edited
I have written up an SQL query to pull reports but I also want to include the thread of all the tickets with it. I tried looking this up but all I see is "You'll have to write your own query"I'm stuck and looking for help.Link to query
Export report with thread body?
- Edited
Tickets are spread across multiple tables. ost_ticket, ost_thread with pieces of information in at least another half dozen tables. So yes, you would have to look at the database structure and write your own query for that.I think that the way it works is you look at ost_ticket and get the ticket_id. Then you look up the thread_id in ost_thread_event. Then you look up all entries in the ost_thread_entry where thread_id matches.
- Edited
I was able to find something while searching.This is able to pull the body of the thread which is what I want but I want to combined it with the above report.https://hastebin.com/erohasunib.sql I am very new to SQL and unsure how to do so but I want to take this and combined it with what I posted above.
2 years later
Hi Walt,
Can you please send the mysql query for Export report with thread body?