Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Export Ticketing Thread

Can someone teach or help me how to generate full reports ticketing? I want to see all ticket thread. Maybe teach me from using phpmyadmin or etc.

I'm using osticket v1.10
image

Comments

  • edited May 18
    Maybe something like this 

    SELECT Entries.`created` AS `timestamp`, Entries.`poster` AS `username`, Entries.`body` AS `message`
    FROM
    (SELECT * FROM `ost_thread` WHERE `object_id` = 1 AND `object_type` = 'T') Thread
    LEFT JOIN
    (SELECT * FROM `ost_thread_entry`) Entries
    ON Thread.`id` = Entries.`thread_id`

    UNION ALL
    SELECT Events.`timestamp` AS `timestamp`, Events.`username` AS `username`, Events.`state` AS `message`
    FROM
    (SELECT * FROM `ost_thread` WHERE `object_id` = 1 AND `object_type` = 'T') Thread
    LEFT JOIN
    (SELECT * FROM `ost_thread_event`) Events
    ON Thread.`id` = Events.`thread_id`
    ORDER BY `timestamp`
  • I try but no details show..
  • You need to replace the 1 with the id of the ticket you want shown
  • edited May 18
    Thank you.. But how do i add to this csv file?image
    Screenshot_2.png
    1878 x 549 - 67K
  • Where do you want the data to be displayed?
    Each entry at the end?
  • Alternatively, There is a 3rd part reporting mod [now a plugin] by forum member @scottro that you can check out from software-mods.com. There was also another reporting 3rd party mod that was posted on the forums previously but I cannot find it right now.
  • @ntozier I'll have a check also.. thanks
Sign In or Register to comment.