- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2015 03:52 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2015 06:23 AM
Hey Bhushan Bhagwat
I was thinking more like this...
- 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2015 06:23 AM
Hey Bhushan Bhagwat
I was thinking more like this...
- 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2015 10:31 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2015 11:45 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2015 11:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2015 12:08 AM
Thanks.
I created the report. However, on running the report following is displayed
Number of rows removed from this list by Security constraints: 6