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......
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)