Skip Navigation
Expand
File attachments for a contact from all incidents
Answer ID 5375   |   Last Review Date 07/15/2019

How can I create a report which shows all attachments for a contact from all incidents?

Environment:

Analytics, File attachments

Resolution:

You can create a custom report to find all the incident attachments from a contact. You will have to join the incidents, fattach and contacts tables with appropriate filters.

So to summarize:

  • In your custom report you will be using incidents, contacts and fattach (File Attachment) tables.
  • Join incidents with fattach using inc.i_id = fa.id.
  • Join contacts with incidents using inc.c_id = co.c_id
  • Use a filter on fattach object with tbl column = 1 (this for attachments associated with incidents only)
  • Use a filter for first name and last name using contacts table (this can be a user selectable filter when report runs)

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.