Create reporting with Work Notes and Additional Comments that links to a Task - Support and Troubleshooting

Create reporting with Work Notes and Additional Comments that links to a Task Issue  In the scenarios where you may want to tie comments to a particular task. You can do this by creating a database view to join the tables where they are stored. Release All

Cause Work Notes and Additional Comments are stored in a table named "sys_journal_field". You can report directly on that table, but for a more meaningful report, you can tie those comments to a particular task (an incident, for example) by creating a database view, joining the "task" table to "sys_journal_field" on element_ID = sys_id.

Resolution Steps to create a database view joining the 'task' table to the 'sys_journal_field' table below: 1. Navigate to System Definition > Database Views. Click "New" 2. Give it a name, and then a description and label if you'd like. Click "Submit". 3. Open the newly created view, and click "New" next to "View Table" and add table "sys_journal_field" with a "Variable prefix" of "jou". Click "Submit". 4. Now open the "sys_journal_field" View Table, and add View Fields "Element", "Element_id", and "Value". 4. Add a second View table "task", with Variable prefix "tsk", and "Where clause" tsk_sys_id = jou_element_id. 5. Personalize the form and add the "Left join" field. Check it to make it "true". Click "Submit". 6. Open the "task" View Table, and add View Fields "number", "sys_id", and "sys_created_on" (and anything else that you would like to see in a report). Click "Submit" 7. Create a report against the new Database View.