[ Report ] People worked on incident

bhushan1
Kilo Contributor

Dear All,

I need help in creating a report with following criteria,

People names who have worked on an incident irrespective of its current status.

Example - An incident is created with a CI that is not part of my support group. Also, initially the incident is assigned to a different assignment group. As the investigation proceeds, The incident comes to my assignment group and i assign the incident to myself.

I fill in the required updates and pass it on.

So, my role in the incident was to provide updates as required.

I need a report which tells me all the incident on which i have worked on irrespective of its current status, CI or assignment group.

Thank in advance!

Bhushan

1 ACCEPTED SOLUTION

Hey Bhushan Bhagwat



I was thinking more like this...


TimeReport.png



  • Reporting on Time Worked [Task_Time_Worked] so I can get ANY task type, not just incident.
  • Don't bother with inc_sys_updated_by - that's just hte last person who touched the incident.   Its got nothing to do with historical values.   Instead I queried on the User reference in the Time Worked record, which stores the person who processed the time (by being on the form and hitting save)
  • I'm also grouping by Task, since a time record will be entered for every save.   If I update the same record 1000 times in a month, that's 1000 line items I'll have to deal with.


Hope that helps.


View solution in original post

24 REPLIES 24

Hey Bhushan Bhagwat



I was thinking more like this...


TimeReport.png



  • Reporting on Time Worked [Task_Time_Worked] so I can get ANY task type, not just incident.
  • Don't bother with inc_sys_updated_by - that's just hte last person who touched the incident.   Its got nothing to do with historical values.   Instead I queried on the User reference in the Time Worked record, which stores the person who processed the time (by being on the form and hitting save)
  • I'm also grouping by Task, since a time record will be entered for every save.   If I update the same record 1000 times in a month, that's 1000 line items I'll have to deal with.


Hope that helps.


Thanks for your response. It is certainly helpful. However, I am unable to add the 3rd filter as you have mentioned in your screen shot. "Task.Assignment Group"


Does it require any special roles and/or rights?



BR,


Bhushan


Hi Bhushan, in the field options at the conditions, go to the last option... it should say something like "Show Related Fields". The list will refresh again and then select the one that says: Task ==> Task Fields. The list will refresh again and now you can select Task.Assignment Group



Thanks,


Berny


Because a picture is worth more than a thousand words... Here goes a picture of the steps



Condition-RelatedFields.jpg


Thanks.



I created the report. However, on running the report following is displayed



Number of rows removed from this list by Security constraints: 6