Hello,
I have OSticket 1.12 Installed (migrated from 1.10) with Attachement Storage On disk
System : Windows 2008 IIS7.5
Everything is working good
I want to extract all attached files in a ticket for certain help topics i'm still exploring DB, after viewing the forum i ended with a sql script like this
`
SELECT f.key, f.name ,attach.name, thre.body, thre.poster , t.number, ost_ticket__cdata.agence , lisit.value
FROM ost_file f

INNER JOIN ost_attachment attach
ON f.id=attach.file_id

INNER JOIN ost_thread_entry thre
ON thre.id=attach.object_id

INNER JOIN ost_ticket t
ON t.ticket_id=thre.thread_id

INNER JOIN ost_ticketcdata
ON ost_ticketcdata.ticket_id=t.ticket_id

INNER JOIN ost_list_items lisit
ON lisit.id=ost_ticket__cdata.agence

WHERE f.bk='F' `

The problem is : it's showing only attachment in thread response not the uploads from custom form attached to the ticket
i don't know how to link attachment type "E" with very high object_id to the ticket itself

    First thing I see is that you are using the ticket__cdata table. This is a temporary table and you should probably not be using it to extract data from the database.

    Second thing is I do not know if custom upload fields use the Attachments::Filesystem plugin. If it does then I image that it would store the attachment in the ost_form_entry_values table in an entry for that ticket. So you would have to look at the ost_form* tables to reverse engineer how it stores dynamic form data.

      Thank you ntozier for your feedback .
      I will see these tables and try to get it working

        3 years later

        BReflex

        For the type 'E' entries, the key is created by the following php functions: abs(crc32('E[field_id][entry_id]')), which for example would be abs(crc32('E441415')) if the field_id = 44 and entry_id = 1415. This translates to a value of 3138309956.

        You can use the following site to test the crc32:

        https://www.functions-online.com/crc32.html

          Write a Reply...