Report of incidents with attachments

Joe78man
Mega Contributor

‎03-19-2019 01:19 PM

Hello guys, 

I'm running a report of the incidents and would like to be able to pull whether the incidents have an attachment or not. A count of attachments would suffice. Is there any field that pulls this from the table 'Incidents'?

Thanks,

Labels:
0 Helpfuls
  • 5,597 Views
2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo Patron

‎03-19-2019 01:21 PM

You will have to create database view, then use the filter tool to create a report against that view. Like this:

 

 

 

Screenshot 2016-06-20 19.55.03.png

 

Screenshot 2016-06-20 20.00.42.png

 

Regards,

Sachin

Joe78man
Mega Contributor

‎08-23-2019 01:12 PM

So much trouble and permissions (I'm not allowed to pull from sys_whatever tables) for something so simple.

It'd be useful to have a field that simply counts the attachments as there is for priority change, reassignment, reopen, pending.