Database views

antonio30 · ‎01-12-2017

I am attempting to combine the Incident table and the Task table to create a custom report in ServiceNow. When reporting using the Database view I can pull most of the information except the additional comments and work notes don't come over. The fields display but they are empty. I can use a report from the Incident table and the additional comments and work notes display just fine. Any thoughts or ideas on what I may be doing wrong with my Database view?

drjohnchun · ‎01-13-2017

OK, that helps. First, you're creating a view using Incident and Task SLA, not Task - I see that this caused confusion in the replies (Task SLA is NOT extended from Task, so you need a database view to join them). Second, you don't need to use sys_journal_field (unless there are reasons I'm not aware of).

I have recreated the view as follows and it shows values for Additional comments, Work notes, and Comments and Work notes as you can see below:

View solution in original post

Deepa Srivastav · ‎01-12-2017

Work notes and additional comments are in sys_journal_field table, you have to add that in the database view.

Mark Correct if it solved your issue or hit Like and Helpful if you find my response worthy

Arnoud Kooi · ‎01-12-2017

Incident is a extend of task, you have all the Task fields available in incident, you do not need a database view...

https://developer.servicenow.com/app.do#!/training/article/app_store_learn_dev_platform_intro_helsin...

drjohnchun · ‎01-12-2017

To see Additional Comments and Work Notes, there's a journal_list field called comments_and_work_notes [Comments and Work notes] that combines both in chronological order. Please see if it meets your requirements.

Hope this helps.

Please feel free to connect, follow, mark helpful / answer, like, endorse.

John Chun, PhD PMP

Winner of November 2016 Members' Choice Award

antonio30 · ‎01-13-2017

Here's what I have see pic below. I can display the comments and work notes fields, but for some reason the information in those fields are not displayed in the report.