How to create report on Interaction of incident ?

[Amol adsare]

Hi,

I want to create a report of the incident that having an interaction that will show you how many incidents having interaction or interaction count

Thanks,

Amol

[palanikumar]

Hi,

Relation between interaction and incident is available in table interaction_related_record.

You can create report from this table and select group by task to get all the incident with interaction and respective count

Thank you,

Palani

[Amol adsare]

How can you find a relation for the task table? I want to create a report on the task table and show incident and interaction count

[palanikumar]

Hi,

You can get the Count of interaction only if you generate report form interaction table

In case you want report from task table, you can use related list condition. You will get list of task with atleast one interaction but will not report the count of interaction.

You can follow the below steps:

1) Create a new report

2) In table dropdown choose Task table and click next

3) On the right side you will see list of all record. 

4) Add a related list condition and choose Interaction Related Record -> Task as below screenshot (This will make sure tasks with at least one interaction is displayed):