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

drjohnchun · ‎01-13-2017

Can you click on Personalize List (the gear icon) and add "Comments and Work notes" as shown below:

drjohnchun · ‎01-13-2017

In my List View, I can see values in separate Additional comments and Work notes columns, so I'm not sure why you're not seeing them. Are you still using a database view or are you using a List View for Incident?

antonio30 · ‎01-13-2017

Yes I can add Additional comments and Work notes but return the same empty values. See below

drjohnchun · ‎01-13-2017

Which table are the columns "SLA definition" and "Stage" from? Can you show a screenshot of your Database View?

antonio30 · ‎01-13-2017

Please see