Database view between incident and change request tables

[_-jasonr-_]

Hello,

I am using a database view (DBV) to create a union/join between the Incident and Change Request tables. Management needs to be able to report against all fields on both tables into one list report.

The DBV sets the Incident (inc) & Change Request (chgreq), ordered 100 inc & 200 chgreq, with a left join on the chgreq.

If I am understanding this article correctly ServiceNow Admin 101: Observations on Database Views, Part I

Then I should be able to link all records on the tables with a where clause of inc_sys_id = chgreq_sys_id. Or am I misunderstanding something the author is explaining?

Any help from the community to help me understand the development process for this would be appreciated.

Thanks,

Jason

[Chuck Tomasi]

Just to clarify Chris' first option - making a report on task will get you access to all the fields they have in common (inherited from task), but you won't have access to the incident and change_request specific fields (like caller_id from incident) using this method. You can't dot-walk down, only through reference fields.

[Chris M3 · Accepted solution]

You can actually.. Scroll down to the bottom the field list, and you'll see a list of fields in Red.   These are fields from the extended tables, and you can include them from more then one table.

[Chuck Tomasi]

Well that's cool. Looks like this old dog can still learn a new trick. Thanks for sharing.

[_-jasonr-_]

Thanks Chris. I will be testing your advise today and I will post my results.