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

How to get ticket attachments by direct query

edited November 13 in Mods and Customizations
Hi,

As i need to get only attachment of particular tickets directly from database.

Please let me know is it possible. If possible then please provide your advice to get through mysql query.


Thanks in advance......
Tagged:

Comments

  • This does not appear to be a suggestion of feedback.  Moving thread to Mods and Customizations.
  • I think this is what you are wanting:



    SELECT * FROM ost_file f LEFT JOIN ost_attachment a ON (a.file_id = f.id) LEFT JOIN ost_file_chunk c ON (a.file_id = c.file_id)
Sign In or Register to comment.