Incident-task number inside incident report

[Donatello Falco]

Hello everyone,

I trying to create an incident report (since incident table) that even showing the number of task created inside the incident.

this is the id interested:

Unfortunatelly, I'm not able to discover the task number in the suggested "chooses column":

I can see all the incidents value but I cannot find the task number to show in columns report:

Can you help me to solve this problem? 

Thanks, in advance, for your support.

Donatello.

[Abhijit4]

Hi,

You won't be able to dot walk to get Task Number through incident table as incident table is not having any reference field which refers to Task. 

What you can try is create report on Task and dot walk to incident record to get required fields. or The other option is to create database view to merge those two tables and use it for reporting purpose.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Thanks and Regards,
Abhijit
Community Rising Star 2022

[dmathur09]

Hi Donatello,

It will not be visible since there is no field as task number on the incident form.

You can do the other way around. Reporting on incident task and then dot walking to the incident and setting up the filter.

Regards,

Deepankar Mathur

[Anurag Tripathi]

Hi,

You can create a report on incident task and include the incident number in it. Group it by incident number maybe.

-Anurag

[Donatello Falco]

Hi all,

sorry for the late reply,

unfortunately, not all incidents have the Associated activity, and in this case, I don't have access to DB.

Thank you so much for your support.

Donatello.