Reporting on Activities

[joedziedzicbbt]

Does anyone know if i can report on Public Comments and IT Work Notes that are saved as an activity? I have tried setting up the reports, and have searched both the Incident and Task tables, and I can not seem to find them.

[joedziedzicbbt]

Thanks Wesley. I was able to get that report to work, however, it is only pulling an Element ID. All of the journal entries are on the Task table, as I had expected, but is there any way to view the actual Incident or Request number the journal entry was made on?

[w_bouwer · Accepted solution]

The element ID is the sys_id of the record you are looking for. You could make a database view that connects sys_id with the task record:

1. Go to database views and create a new database view.
2. Add a view table 'sys_journal_field' with the view fields 'Element','Element_id','Value'. Variable prefix is 'jou'. Check left join to true.
3. Add another view tabel 'task' with the view fields 'Number','Sys ID'. Variable prefix is 'tsk'. Check left join to true.
4. Add a where clause to the task table 'tsk_sys_id = jou_element_id' (where task sys_id is equal to journal element sys_id).

Now when you test it out with the 'try it' UI action, you can add fields to the view of the records. You can report on this table as much as you want 🙂

Regards,

Wesley

[joedziedzicbbt]

Wesley,

That worked perfectly. Thank you for assisting me with a solution, and the crash course in Database Views.