[ Report ] People worked on incident

bhushan1 · ‎07-07-2015

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

Uncle Rob · ‎07-08-2015

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.

View solution in original post

bernyalvarado · ‎07-09-2015

Oh, that's a whole different issue.

That's because you have an ACL rule which is preventing you to see the desired records/fields.

You may want to navigate directly to the Time Worked table and then to the Incident table and then Task table; and try to identify where you don't have access. From there you can then you to the ACLs of that given table/fields and then decide whether there's a role with read access that you could assign to yourself or if you need to be member of a group or if you actually want to modify the security rules of the ACLs.

I hope this is helpful!

Thanks,

Berny

rlehmann · ‎07-09-2015

Sorry to hi-jack the thread, but I too am working on this exact report.

When I run the report, zero rows are returned.

I then went to task_time_worked.list and there are no entries, so expect the table is empty.

Is there something I need to enable in order for this table to populate?

If it makes a difference, we are currently on Dublin Patch 8, although I did create the same report in a demo instance of Fuji Patch 4 and experienced the same results.

Thanks

Ron

jas101 · ‎08-06-2015

Hi all. Is there any feedback on Ron's request above - I am having the exact same issue i.e. zero results returned. Many thanks. Daniel

bernyalvarado · ‎08-06-2015

Hi Ron Lehmann, dasi,

If you run task_time_worked.list and your see something that says: Rows not shown due to security constraints or something like that, then your problem is in the ACLs that are affecting that table. Make sure you validate the read ACLs at the table level and then table.* and then table.fields.

If you don't see a message like the one I mentioned above, then 2 things may be ocurring:

a) you don't have records at all on that table

b) you may have an onBefore query businessRule which is preventing you to see the records of that table

Thanks,

Berny

jas101 · ‎08-06-2015

Thanks for the reply Berny.

I checked the table and there are no records at all i.e. nothing is populating in the table (I have full admin rights in SN).

As per Ron's prior message is there something we need to do/activate to make this table populate going forward? Thanks.