Database views

[antonio30]

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 · Accepted solution]

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:

[antonio30]

John, thanks for the reply, I just used the exact view as above (literally copy/paste), but results still yield a blank value. Any clue what I may be missing?

[drjohnchun]

Do you indeed have Additional comments and/or Work notes for those tickets? Can you open the forms for INC0022081, INC0048000, etc.? Some screenshots may help just to make sure.

[antonio30]

John, Here's INC002281,

[drjohnchun]

Your screenshot is not showing Additional comments or Work notes but only Activity (not the same). Can you scroll down further and see if you can find Additional comments or Work notes?